Qlikview Set Analysis – Define Specific Value Against Current Selection

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 first 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 – Define Specific Value Against Current Selection

In the following example:

  • Identifier will represent the records of the current selection:     $
  • Modifier will define a specific “Position” against the current selection:     <Position={‘QB’}>

The base chart is a simple SUM of the “Actual” points scored by each Team:

Qlikview Set Analysis

Now, let’s say you’d like to see how many points that a specific Position have scored?  You could filter on the field “Position”, and view updated chart:

Qlikview Set Analysis

However, it would be more useful to see how the position “QB” compared to other positions, and ultimately against the total “Points”.

This is where using Set Analysis comes into play!

In the following chart, I will now setup a separate expression for each value in the “Position” field:

Qlikview Set Analysis

In the chart above, I defined the following expressions:

  • Points:  =SUM(Actual)
  • QB: =Sum({$<Position={‘QB’}>}Actual)
  • RB:  =Sum({$<Position={‘RB’}>}Actual)
  • WR:  =Sum({$<Position={‘WR’}>}Actual)
  • TE:  =Sum({$<Position={‘TE’}>}Actual)
  • K:  =Sum({$<Position={‘K’}>}Actual)
  • DST:  =Sum({$<Position={‘DST’}>}Actual)

And that’s all there is to it!  Now you can view the total points for each team, along with a breakdown of total points for each Position, all in one chart!

 

 

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