Global Calendar

Having a well structured calender within your qlikview app allows you to build faster charts and reports. Speak to your internal customers about their report layouts and you’ll see that most people have a common sense on how to combine data over time. Below you will find a list of fields which we recommend to add it to your default calendar. Definition:

Continue Reading

extended dataloader


Continue Reading

QlikView Generating Year over Year Targets

From time to time you have to create budget figures upon a percentage change compared to the last year. This can be a little bit difficult, depending on the complexity of the KPI. The following example is build upon a pre-cleaned datamart and shows how you create the monthly figures for you budget.

As you can see the real magic here is done in the FOR-TO-Loop, here it shows a cumulated budget figure, but you can easily change to a mothly figure!


Continue Reading

Load multiple GoogleAnalytics-Properties at once w/ dynamic metrics in QlikView

Our objective is to load GoogleAnalytics data, seperated in months with a dynamic metric, fixed dimensions and for multiple Properties. To achieve this we’re using the QlikView addon: QVSource. The script contains the following (important) variables: gAppId = googleAnalytics PropertyId vMetric  = the dynamic metric, we want to load (note that this script will only load 1 metric per request) First of all we need to define our googleAppIds within a static table.

Now we have to loop through our table:

  As our loadGoogleId Sub is still missing we have to add this here:

Here is just a loop to address every single month within our… Read More

Continue Reading
qlik view first quick chart

Loading Google Analytics with QlikView

General To keep reports compatible, the following dimensions are alway loaded as a minimum: ga:browser ga:deviceCategory ga:pagePath ga:date Add Measures Now as the dimensions are set, you can add up to 5 measures to be grouped by and displayed. QlikView Load Script

If you don’t have QVSource running, you can use the query explorer and the url with the (1hour) token included to load the data like this. Then I recommend that you put this token into a variable to which will be passed to the script while you wanna load it. Enhancement If you have multiple sites you wanna load, just pack the hole load script into a… Read More

Continue Reading

QlikView Script Sub for Dataloading

Sorry, typo in the path variable, now fixed! Enjoy the script!

Continue Reading

Project Documentation with github and markdown

A very important step while implementing more or less complex solutions is the availability of a documentation. While I’m really a fan of version based work, I will describe a quick an simple way, how I document my projects with github and markdown. For all of you who don’t know markdown, it’s a simple “what you mean is what you get” syntax which can be compared to LATEX. (If you don’t know this eather, pls. give a search engine a visit) 😉 So what you acutally need is: GitHub Account TextEditor (min.) if you are the more “what you see is what you get” person, you’ll find a lot of… Read More

Continue Reading

Prepare a new qlik project

Intro If you prepare yourself for a “seeing is believing” workshop or going to start a new qlik project. Be aware that you should prepare your work environment!  System Requirements Based upon the size of your data and the number of clients you need to “size” your server or developer workstation. For a minimum developer workstation you should at least have:  500GB HardDrive (2 Partitions 100,400) >= i5 (min 2CPU) 8 GB RAM For a minimum server you should at least have: 500GB HardDrive (2 Partitions 100,400) >= 4 CPU (current tech) 16 GB RAM If you wonder why the server needs “more” ressources, it’s because each user will generate… Read More

Continue Reading

QlikView – Color Blend by Dimension Value

Overview Sometimes you wanna define a “color schema” by the values of a dimension. The easiest way is to generate a mapping table where each dimensionvalue gets an color assigned. Downloads First load the color table as CSV from here and save them into the same folder where you wanna create and run the QlikView Worksheet:  Sample

If you wanna update the colors “online” just replace the first load with:

After this we create a bar chart with the YourFieldname as Dimension and 1 as Formula: To color it as we wanted to, we will edit the background formula for the formula as here: Which leads us… Read More

Continue Reading