Monthly Archives: January 2010

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

By Stefan Walther 11 Comments
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 [...]

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

By Stefan Walther 8 Comments
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 [...]

QlikTip #1: Transferring Current Selections to Excel-Export (translated)

By Stefan Walther 10 Comments
Posted in QlikTips

While driving this blog only in German the most viewed article was “QlikTip #1 – Export the current celections to Excel”. So this will also be the first article translated to English. (The original German article can be found at http://www.qlikblog.at/9/tip-statusboxauswahlstatus-in-excel-export-integrieren/) The functionality in QlikView that any object-content can be easily exported to Excel is [...]

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

By Stefan Walther 16 Comments
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) [...]

A little tool for creating nested if-statements

By Stefan Walther 27 Comments
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 [...]

qlikblog.at is now published in English!

By Stefan Walther 5 Comments
Posted in Site News

About four months ago I have created this blog for sharing my knowledge and ideas about business intelligence and especially QlikView. In the last weeks I have received so many mails! Thanks! But most of the mails I received were targeting one topic: “Why is your blog published in German” or “Could you please translate [...]