Author Archives: Stefan Walther

QlikTip #22: Restarting/Stopping/Starting services in QlikView 9

Even if already published on another Qlikview related blog I just wanted to have this here because I am using it quite often.For starting/stopping/restarting the QlikView Windows-services of QlikView server in version 9 I have prepared three batch-scripts which I call on demand:Restarting all QlikView related Windows-services@echo offREM -------------------------------------------------------REM - File: QlikViewServer9_Restart.batREM - Description: Restart's [...]



Nice Read #1: Gartner’s Magic Quadrants 2009/2010 and Qlikview

Gilles from www.quickqlearqool.nl has written a nice review of the new Gartner’s Magic Quadrant 2010:The most interesting fact in Gartner’s analysis is that QlikTech/QlikView is not a visionary anymore!Some quotes from Gilles article:THERE ARE NO VISIONAIRIES ANYMORE!! Even Qlikview isn’t a visionary anymore.… the explanation for Qlikview not being part of the visionaries anymore is [...]



QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side

Just a very short (very, very short) tip today.I was asked how one could run QlikView 8.5 and QlikView 9 one one system …That’s absolutely no problem.During the installation of QlikView 9 Desktop (when having QlikView 8.5 already installed) just choose another installation path as suggested (e.g. C:\Program Files\QlikView_9 instead of C:\Program Files\QlikView) and these [...]



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

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 [...]



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 enable the [...]



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 which can be [...]