topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275544#M400717 <HTML><HEAD></HEAD><BODY><P>Some of the fields in [Age Group] do not have data. How would the expression we altered?</P></BODY></HTML> Wed, 01 Feb 2017 19:39:44 GMT evansabres 2017-02-01T19:39:44Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275542#M400715 <HTML><HEAD></HEAD><BODY><P>I have two fields; fanID and [Age Group]</P><P></P><P>Age group is a field that has values such as 20-29, 30-39, etc,.</P><P></P><P>I want to count the number of fanID records in each age group.</P><P></P><P>How would I set up an expression to do this?</P></BODY></HTML> Wed, 01 Feb 2017 19:33:16 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275542#M400715 evansabres 2017-02-01T19:33:16Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275543#M400716 <HTML><HEAD></HEAD><BODY><P>Hi Evan,</P><P></P><P>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:</P><P></P><P>count(distinct fanID)</P><P></P><P>that simple!</P><P></P><P>cheers,</P><P>Oleg Troyansky</P><P>Upgrade your Qlik skills at the <A href="http://masterssummit.com/">Masters Summit for Qlik</A> - coming soon to Munich, Germany!</P></BODY></HTML> Wed, 01 Feb 2017 19:35:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275543#M400716 Oleg_Troyansky 2017-02-01T19:35:57Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275544#M400717 <HTML><HEAD></HEAD><BODY><P>Some of the fields in [Age Group] do not have data. How would the expression we altered?</P></BODY></HTML> Wed, 01 Feb 2017 19:39:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275544#M400717 evansabres 2017-02-01T19:39:44Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275545#M400718 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>No changes to the expression needed.</P></BODY></HTML> Wed, 01 Feb 2017 19:45:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1275545#M400718 Oleg_Troyansky 2017-02-01T19:45:38Z