QlikView extensions and the cycle plot
If we are going to work with advanced data visualization in QlikView, we have to get used to working with extensions. We can either develop the QlikView extension ourselves or use open source extensions that are available in Qlik Branch (http://branch.qlik.com).
For example, we are presented with the challenge to find a better way to visualize year-over-year (YoY), week-over-week (WoW), or any other period-over-period analysis. The following line chart demonstrates how difficult it can be to compare a large number of periods:
A cycle plot (Cleveland, Dunn, and Terpenning, 1978) offers a alternate way to compare a large number of periods. The following cycle plot is a QlikView extension that displays the average sales by weekday in each month and compares it to the total average sales represented by a flat horizontal line:
Exercise 12.6
Let's create this cycle plot in Sales_Perspective_Sandbox.qvw
using the following steps:
In the
Ch. 2
folder of the book...