Category Archives: Load Scripts

QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements …

By Stefan Walther 7 Comments
Also posted in Data transformation, Development /QV Developer, QlikTips
I have recently received the question why there is no SELECT-CASE or SWITCH statement available in QlikView within load-statements.Sure, if you are looking into the reference-manual or into the help file, you’ll find the SWITCH-CASE-statement, but this is a control statement so it cannot be used within a load-statement, e.g. this is possibleswitch I [...]


read more


A little tool for creating nested if-statements

By Stefan Walther 20 Comments
Also posted in QlikView-Online-Tools
Nested If-statements are sometimes necessary in QlikView- load-scripts, unfortunately.They are quite difficult to read and very tricky to create and especially to debug.In the last recent months I had a lot of projects where a tenfold nesting of if-statements was not uncommon.After struggling with these nested ifs for a while I decided to create a [...]


read more