Using grid charts – part 1

In QlikView grid charts are those kind of charts which you don’t see very often. One of the reasons, I think, is because they need relevant use cases. A time dimension for example is a good one for visualizing points in time and average measures that correspond.

In this chart I chose to visualize the average temperature over months and the days in that month. The bubble size is the height of the average temperature. This gives a nice overview of the temperatures during the year. You will be visually told what times are warm or cold.


In this example I used a simple ‘avg(Temperature)’ expression. The two dimensions I used are ‘Day of the month’ and ‘Month of the year’. You could, with this same expression, also visualize the average temperature of a specific hour of the week. An example could be:

Temperature per hour of the day

To try some visualization for yourself I posted the data set that was used for these grid charts.

You can download it here.

In a next part about grid charts I will explain a bit more about intuitive and interactivity that will make this chart easier to use.


Have fun!