Set Analysis

[evansabres]

I have two fields; fanID and [Age Group]

Age group is a field that has values such as 20-29, 30-39, etc,.

I want to count the number of fanID records in each age group.

How would I set up an expression to do this?

[Oleg_Troyansky · Accepted solution]

Hi Evan,

you don't need Set Analysis for that. You simply need a chart by age group (use Age Group as a Dimension) with the expression:

count(distinct fanID)

that simple!

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Munich, Germany!

[evansabres]

Some of the fields in [Age Group] do not have data. How would the expression we altered?

[Oleg_Troyansky]

That depends on what would you like to do with those rows where Age Group is missing. You can ignore them by suppressing the null values of the Dimension, or you can show them as a "missing" Age Group.

No changes to the expression needed.