Category Archives: Macros

QlikTip #32: Exporting multiple QV objects to a single Excel document

This article demonstrates how you can easily export multiple QlikView objects to a single Excel document without writing a lot of macro code.

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) […]