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.…
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.…
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?…
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!
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…
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…
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…
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…
Lucian Cotea 