Using dimensions on the X and Y axis and plotting measures at the intersection is a useful visualization. The out of the box solution in QlikView is the Grid chart.
The grid chart does have limited options for representing data.
The Pivot Table can be a more robust alternative. A Pivot Table grid (Crosstable) is created by dragging one of the dimensions to the horizontal position.
Now we can represent the measures as a heatmap by coloring the background of the cells. This is frequently a more effective visualization than circles, .
We can also display numbers in the cells.
We can display multiple expressions per dimension.
Here I show both the number and a linear gauge allowing for clear comparisons between Regions. The user can swap the dimensions if desired.
You can mix colors and numbers to show interesting patterns. Here’s a map of average Sunrise/Sunset/Daylight for my home town.
Maybe it’s not a design winner, but I find it interesting.
We can blank some cells in the grid to make meaningful shapes, in this case a rough outline of the United States.
All of the examples shown can be downloaded here.
A few styling tips:
- Style format “Clean” is a good starting point for managing border lines and spacing.
- “Custom Format Cell” Border before/after (double line) can be used to create white space between rows as shown in the Minimum Wage example above. Also, setting Text Size to other than the default 100% can be useful.
Do you have any examples of Pivot Grids to share?