RSS-Feeds & Newsletter
Category Archives: Macros
QlikTip #30: How to delete existing QVD files via load-script
In some delta-load scenarios it may be necessary to delete specific QVD files from within your load-script (QVD-Generator).
This article shows three completely different ways to achieve that goal.
QlikTip #9: Deleting variables via user-interface, within the load-script or by using macros (translated)
There are three different options for deleting variables in QlikView: Deleting using the “Variable Overview” Deleting within the load-script Deleting using macros Option 1: Deleting using the “Variable Overview” For deleting a variable using the “Variable Overview” within the windows client just follow the steps below: Call the “Variable Overview” dialog (Menu => Settings => [...]
QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents
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 [...]
QlikTip # 18: A workaround for passing parameters to QlikView-macros
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 [...]
QlikTip #17: Simulating the $(include) command in QlikView macros
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) [...]
Stefan WALTHER
QlikTip #32: Exporting multiple QV objects to a single Excel document
Also posted in QlikTips