Category Archives: Development /QV Developer

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, Load Scripts, 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


QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents

By Stefan Walther 6 Comments
Also posted in Macros, QlikTips, Settings
When opening documents with macros the end-user will be shown a dialog to define the desired macro-security/module security (in the QlikView Windows Client or the QlikView IE Plugin):But what, If you do not want that the end-user has to option to select the desired macro security/module security?You can (e.g. as a system-administrator) globally enable the [...]


read more


QlikTip # 18: A workaround for passing parameters to QlikView-macros

By Stefan Walther 8 Comments
Also posted in Macros, QlikTips, QlikView 9
When calling macros from the user interface you cannot pass a parameter to the function called in QlikView.This behavior is quite annoying …!But the workaround explained here will show you a possibility how you can “simulate” passing parameters to macro-functions:The idea behind is quite simple. In QlikView 9 we have now actions which can be [...]


read more


QlikTip #17: Simulating the $(include) command in QlikView macros

By Stefan Walther 12 Comments
Also posted in Macros, QlikTips
Within load-scripts in QlikView there is the useful “$(include)” command available for including files containing some script to be used within the load-script.Doing so it is easy to encapsulate and reuse some code used in several QlikView applications.So organizing your code in load-scripts is easy, you can use several tabs and the $(include) command, whereas [...]


read more


A little tool for creating nested if-statements

By Stefan Walther 20 Comments
Also posted in Load Scripts, 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