Monthly Archives: July 2013

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

QlikView Macros – Useful collection

Macros are very important feature of QlikView. Here is a collection of useful functions I encountered over the years. I will update this collection whenever I get the chance and you may suggest new code. Please note that some of

Tagged with: , ,
Posted in Macro

QlikView & Google Maps – How to automatically spell-check customer addresses and get location information

Using Google Geocoding Service we can convert addresses into geographic coordinates. Before converting, the service is performing a spell-check on the address and return the result. Let’s say we have a list of customers: Addresses: LOAD *, RowNo() as ID

Tagged with: , ,
Posted in Google Maps

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

Business Intelligence: The indispensable tool!

Let me ask you a question: If you’re on the way to work and realize that you forgot your cellphone at home, what you do? I bet you’ll rush back home to get it! If 20 years ago, managers were

Tagged with: , , ,
Posted in Business Intelligence

QlikView & Google Maps – Real Estate Demo

Using Google Maps in Real-Estate business help us to add context information to the portfolio. We can automatically calculate information like the distance from the nearest kindergarden or metro station, depending on customer requirements. Captions available in English and Romanian.

Tagged with: , ,
Posted in Google Maps

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