I have been working with fantasy football data for a while now, so it is fun to come up with new ways to display the data. At the same time, it has been a great way to learn about the various features and objects available in Qlikview. In this example, I am going to show you how to setup a Qlikview Mini Chart.
The Qlikview Mini Chart is a representation mode for Straight Table Chart cells, and displays the expression value in a miniature chart with the expression aggregated over an extra dimension field. The chart will be drawn in the available table cell, and the mini chart dimension can be defined and visual settings for the chart can be modified via the Mini Chart Settings button. Mini charts will not be displayed when exporting to Excel.
How to implement Qlikview Mini Chart
Here are the steps to accomplish this task:
I have the following Straight Table Chart, displaying the Sum of Fantasy Points for each NFL Team in 2014:
In the properties of the chart, I highlight the expression and select “Mini Chart” in the Display Options section:
Next, I open the Mini Chart Settings. Here is where you can set the dimension of the Mini Chart. In this case, I want to display the data points for each week of the 2014 NFL season. I then chose “Bars” for the display mode of the Mini Chart. You can play around with these settings once you have your own Mini Chart up and running:
In the Presentation Tab of properties, make sure you select the option to Wrap Cell Text to 3 lines in Height. This will give your Mini Chart more space in the cell display:
Once you apply the changes made above, your Straight Table Chart will look like the following, which now contains a column with your newly created Mini Chart:
Taking the example a little further along, I now want to add a “Cyclic Dimension Group” as the primary dimension of my Straight Table Chart. Simply add this as the main Dimension in the Straight Table Chart:
Now, I can quickly cycle through my group to display different dimensions, and my Mini Chart will update accordingly. In this example, I am selecting “Player” as the new primary dimension:
Now you will see “Player” as the primary dimension, and the Mini Chart will now reflect each player’s stats on a weekly basis for the 2014 NFL Season:
You can add multiple Qlikview Mini Charts to your Straight Table. Simply add a second expression to the main Straight Table Chart and follow the steps above:
By using this technique, you have the ability to display additional information in a nice visual format. Using Qlikview Mini Charts is also a nice way to add good comparison features to your charts, making use of less real estate on your dashboard.