Qlikview Trellis Chart

If you search Google for the definition of a Trellis Chart, it is defined as the layout of smaller charts in a grid with consistent format.

The Qlikview Trellis Chart option does not work for pivot or straight table charts. Also, you must define two dimensions. The first dimension is the basis for the “grid” if you will (y-axis), and the second dimension is the actual value that is measured (x-axis) in each sub-chart.

How to implement a Qlikview Trellis Chart

In the steps below, I will demonstrate how to implement a Trellis Chart:

Add a New Sheet Object and select Chart, then go into the Properties

 

Qlikview Trellis Chart

 

Select the “Bar Chart” type and click Next

 

Qlikview Trellis Chart

 

Pick your two dimensions – Make sure these are in the proper order, as the first will be the y-axis across all charts and the second will be the x-axis or the measure of each sub-chart

 

Qlikview Trellis Chart

 

Once you have selected your two dimensions, you will notice a button on the bottom of the Dimensions tab named Trellis. Click on this and check the “Enable Trellis Chart” check box, then click OK

 

Qlikview Trellis Chart

 

Next, enter the expression you would like to calculate

 

Qlikview Trellis Chart

 

When it comes to Sort, I want my Trellis Chart to be sorted by the Expression, so here is how you can set that up. Uncheck any sorts on the first dimension “Player” (y-axis). Then check the Sort by Expression and key in the same formula you used for the chart Expression. Then select how you would like this to be ordered. In my case, I want to see the players with the most fantasy points per year at the beginning. For the second dimension “Year”, check the numeric value box and make it ascending.

 

Qlikview Trellis Chart

 

Click on the “Finish” button to exit the wizard and you will see the initial rendering of the Trellis Chart.

 

Qlikview Trellis Chart

 

As you can see, the Qlikview Trellis Chart is an easy way to view multiple dimension values (in this case Player was the primary dimension, on the y-axis), with each having the same measurement on a secondary dimension (in this case, fantasy points per year, on the x-axis).

For some finishing touches, you can circle back to the chart properties and make the following changes:

  • General – Add Window Title and un-check “Show Title in Chart” box
  • Dimension – un-check the Label box for the second dimension (Year)
  • Axes – Change Primary and Secondary dimension labels to be slanted ” / ” by checking the appropriate radio button options
  • Colors – check the “Multicolored” option, and un-check “Persistent Colors”
  • Number – select Number in format settings, and format to have no decimals. You can add the following as the “Format Pattern” ###########,###.

Click Apply and you will now see a Trellis Bar Chart that looks similar to this:

 

Qlikview Trellis Chart

 

Conclusions

Here is something more meaningful! You can quickly draw several conclusions from the above chart:

  • Peyton Manning has the most fantasy points over the three-year period of 2012-2014
  • Andrew Luck and Ryan Tannehill are trending “Up” when it comes to annual fantasy points over the three-year period 2012-2014
  • Tony Romo and Cam Newton are tending “Down” when it comes to annual fantasy points over the three-year period of 2012-2014

Add in some additional filters to sit on top of this Trellis Bar Chart and you can begin to drill into even more detailed analysis!

 

Additional Content

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

1 thought on “Qlikview Trellis Chart

Leave a Comment