Qlikview Set Analysis – Periods

Qlikview Set Analysis is a powerful tool allowing you to define a specific set or group of values that is different from the current selection specified by a user.  This is a fantastic way to make comparisons in your dataset, as well as highlight specific values against the entire population.  A set expression must be used in an aggregation function and is enclosed by braces { }.

This is the second post in a series that will focus on simple examples of Qlikview Set Analysis.  I could write extensive posts around each topic, but figured it would be easier on the reader by focusing on a core concept of Set Analysis, providing a handful of examples to illustrate the specific concept.

Qlikview Set Analysis – Periods

The base bar chart is a simple SUM of the “Actual” points scored by each Team and Year (2016 & 2017):

Dimensions:  Team & Year

Expression: =Sum(Actual)

Qlikview Set Analysis - Periods

Now, if you would like to only display team “Nirvana” (without having to actually select a filter) and sum “Actual” points for years 2016 and 2017 (without adding the year as a dimension), you add the following into the expression:

  • Expression 1:  =Sum({$<Year={2016},Team={‘Nirvana’}>}Actual)
  • Expression 2:  =Sum({$<Year={2017},Team={‘Nirvana’}>}Actual)

The single Dimension for this chart:  Team

Please note, this is for demonstration purposes.  There are other ways to do this without Set Analysis, but this is an easy way to demonstrate how to setup a simple period over period comparison in a chart, without requiring multiple dimensions and having the user select filters to narrow down the chart display.

The following chart now reflects the updated display, based on the expressions above which use Set Analysis to isolate a team and periods:

Qlikview Set Analysis - Periods

This requires no filtering or selecting multiple dimensions in the chart properties.  It’s a simple way to setup charts to display specific content.  In this example, it will display a specific team and show a comparison of points scored, one period against another (Year 2016 and Year 2017).

Again, this is for demonstration purposes.  There are many other ways to achieve the same goal without using Set Analysis.

 

 

Additional Content

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

 

 

Leave a Comment