QlikView and Google Analytics – primary key issues

The main challenge I’m facing now, is the definition of a primary key, that allows me to build up my own data mirror to google analytics without messing up the metrics. Walking around on the internet, I found a lot of interesting articles about this and the best solution to come up with, seems to be the option to hand over custom variables to google analytics. This custom variables allow you to identify a single session and then you can grep the related data to it! For the historical data, I have to come up with another solution, as the tracking ID will only be implemented for the upcoming periods.… Read More

Continue Reading

QlikView Export ChartTo XLS

This script enables you to export a ChartObject to xls by looping over a field, defined within a variable:

Continue Reading

Read and Write QlikView ObjectIDs by Macro

Here is a short script on how to read and write Object Id’s:

Continue Reading

QlikView Generate Dynamic Variables

Sometimes it could be very usefull to generate variable dynamicaly, in QlikView you can do this easily with a trick inside the load statement of you application! Here is a short example (will give you some examples for a smart usage later):

Continue Reading