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


From QlikView to… Qlik?


I don’t know about you, but I’m finding a little bit difficult to embrace certain aspects of the new brand image that QlikView has adopted.

A fresh color palette has complemented the classic green gradients with warmer colors while a couple of orange circles have filled in for the emblematic QlikView swirls. I think that all these changes have reinvigorated the spirit of the platform, especially because they are aligned to its core values: effectiveness, real business value and simplicity.

To be honest, my only real problem is the transformation of the product name itself. If you recall 1994 (or read this post), in the beginning we used to call our favorite BI tool “Quik View” (maybe not very creative, but representative nevertheless).

After that, the name evolved to QlikView, a designation that is specifically difficult for Continue reading

Heat Map

Last week I found an interesting post about the fatal crashes in the US. It used a fascinating way of representing data and I thought it would be a good chart to complement some of my applications. The idea was simple: create a heat map based on a classic calendar.



First of all, you can find a QVW file with this chart here. You can save it in your QlikView Resource Library so you can easily paste it whenever you need it. I used a simple sales application to create this example. The steps are:

1.- Create a pivot table with 2 time dimensions. I found two options that work really well with this analysis, “Week and WeekDay” or “Month and Day”.


Continue reading