Yearly Archives: 2013

BI Tools – Useful collection

I am going to add here all the programs that helped me during a BI implementation. I am not going to talk about big professional solutions like NPrinting, QVSource or QVReport that everybody knows and love, but about small and handy tools.

Tagged with: , , ,
Posted in Articles, Tools

QlikView – How to duplicate expressions groups

I would like to share with you how to duplicate expressions groups (a long-awaited feature). Using this method you can also duplicate also dimensions groups or set properties to all objects in all your projects in one step. Exciting, right?

Tagged with: , ,
Posted in Articles

QlikView & Google Maps – Logistics

Another cool data visualisation with QlikView and Google Maps. See all the places your cars went in one glance or play GPS history. Happy Qliking!

Tagged with: , ,
Posted in Google Maps

My wishlist for QlikView 12 (NEXT)

In the last years, QlikTech has directed its efforts to a better user experience. That’s great but I believe it’s time for developers to get some attention. There are a lot of things that need to be further developed, as

Tagged with: ,
Posted in Articles

QlikView Development – No keyboard required!

One of the greatest things about QlikView it’s the ease of use. But it’s also very easy to build applications, not just use them. And you don’t have to be an experienced IT person to do it. Here’s is an

Tagged with: ,
Posted in Articles, Business Intelligence

QlikView: Against Intuition

The computers have the bad habit of doing exactly what you tell them to do, not what you want them to do. So, when your computer is doing something else than what you expect, means that it’s something wrong with

Tagged with:
Posted in Articles, Business Intelligence

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