Global Calendar

OHaving 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 […]

Read More →
extended dataloader

 

Read More →
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 […]

Read More →
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 […]

Read More →
QlikView Script Sub for Dataloading

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

Read More →
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 […]

Read More →
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 […]

Read More →
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 […]

Read More →
Lesson 11 – complex data presentation

Overview In this lesson we get to know more complex data diagrams, which are properly suited for “intergroup” analysis. Trellis Trellis graphs serve the same visualization with a uniform scale to visualize different categories. You can decide yourself which dimensions you want to “distinguish”. In the advanced settings you can define the quantity per column […]

Read More →