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…
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…
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…
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…
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…
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…
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.…
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…
If your Google Maps objects doesn’t work anymore in QlikView, you have to change the API call to match the new V3 syntax: Old call: =’http://maps.google.com/staticmap?center=‘ &var_mid_lat&’,’&var_mid_long&’ &zoom=$(var_zoom)’&’ & maptype=’&var_maptype&’ &size=400×400’&’ &key=’&gmap_key &’.jpg’ New call: =’http://maps.googleapis.com/maps/api/staticmap?center=‘ &var_mid_lat&’,’&var_mid_long&’ &zoom=$(var_zoom)’&’ &maptype=’&var_maptype&’ &size=400×400’&’…
Each extension added to the QV Desktop will create a folder in %USERPROFILE%\AppData\Local\QlikTech\QlikView\Extensions\Objects To install your Extensions on the QlikView Server, you need to copy the extension files to %ProgramData%\QlikTech\QlikViewServer\Extensions\Objects
Lucian Cotea 