Tile Grid Maps

Have you ever had one of those “of course I can do that in QlikView” moments? As a Qlik developer it’s not uncommon to find yourself struggling to create a chart or pull off a complex script that nobody asked for, but for some strange reason, you decided to tas a personal challenge. Well, I just had one of those moments.


I couple of days ago I was wandering around my usual blogs when I found a post by Alberto Cairo  where he talked about an interactive visualization created by the FiveThirtyEight team regarding the political preferences in the United States. [By the way, if you don’t follow those blogs you are missing a lot of great stuff!]


Besides being a stunning way to present What-If scenarios, I liked the usage of the Tile Grid Maps, which have become a pretty popular visualization lately. What is a Tile Grid Map, you ask? Well, think of it as a mix between a choropleth map and a table heat map. If you want to see more examples, you can visit Bloomberg, The Washington Post or The New York Times.25_30

It is true that most of the times we strive for more accurate charts but ironically, this technique’s boon is that it disregards the actual size of the regions and translates them to equal-sized shapes (in this case, squares) so it becomes easier to see even the smallest areas. Therefore, this solution is excellent when the geographic size is not the most important thing, but maintaining a loose spatial distribution is.

So anyways… In today’s tutorial we’ll build something like this:

25_27 Continue reading


Just Qlik it: Simple Maps

Today’s ‘Just Qlik it’ focuses on using simple maps in QlikView. I’ve been playing with this kind of objects in Qlik Sense recently and I thought it would be good to remember how we created these cartographic visualizations in the old days.

As the ancient masters taught us, before Qlik Sense, GeoQlik and custom extensions, there were scatter charts…



An easy way to create maps in your applications is to exploit the Google API. As always, the reference material with all the examples is here.

1.- Paste the ‘Google Maps’ tab in your script

2.- Be sure to create the fields for Longitude and Latitude in your data model. If you don’t have this information, you can manually find it online (hahaha) or you can search it within your QV script with a routine like this one: 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