Infographics in QlikView Vol. 2

I was wandering around my usual QlikView blogs when I found a post by Rebecca Camper (follow her design blog, INTUIQLIK for stylish ideas!) where she showed some cool data visualizations from Simon Spring, a canadian designer. All of them were easy to the eye, but I found this one especially interesting: RebCam Coincidentally, later that day I found this other post in LinkedIn that used infographics to illustrate employee satisfaction. It showed some curious numbers about why people stay in their jobs, reward systems and work-life balance.

So anyway, long story short, inspiration came and here’s the second volume of Infographics in QlikView. As you remember, in our last tutorial I showed you how to use bar / block charts, images with transparency and layers to create something like this: informejor
Today, we’re going to work with pivot tables and some images to create these: New2



As always, you can download the ZIP package that contains the QVW, images and data sources needed to create all the objects shown above.

1.- First, we will create a pivot table with two calculated dimensions (same expression for both): Continue reading


Simple Infographics

QlikView has an interesting set of pre-built charts such as bars, lines, pies and scatter diagrams. However, every now and then, it is necessary to give a little twist to these tools in order to satisfy our customers’ hunger for beautiful and useful analytics.


Simple infographics are an easy way to impress a prospect in a demo / SiB event. It is also a good instrument for executive dashboards focused on very visual business users. Yeah, I know… not very useful, but believe me: these things –as simple as they may look– have helped me to sell one or two projects. Even if you don’t have a designer in your company, you can create stuff like this:



In this example I will show you how to create the “Tourism in Paris” chart. As always, you can find the QVW and PNG files here for further reference.

1.- We will use this INLINE table as the data model:

Continue reading