Blog Archives

How to connect QlikView to MS Analysis Services Cube

To get data from a MS cube in QlikView, we need to use the MS Data Engine as a bridge. So, the data will follow this path:  MS Analysis Services -> MS Database Engine -> QlikView. We link the first

Tagged with: , , ,
Posted in Script

Auto reload every 10 minutes – desktop client

There are situations when you want your document to be permanently opened and auto reload without the help of QlikView server. To do that we need the auto reload macro and a trigger. The macro looks like that: Sub ReloadDoc

Tagged with: , , ,
Posted in Macro, Script

Call VBA macro function from the load script

Let’s see how to call a macro function within the script. We will build the function “Inc()” which will increment by 1 the passed parameter and return the result to the script. In the macro editor write: function Inc(Value) Inc

Tagged with: , ,
Posted in Script