https://community.qlik.com/t5/App-Development/Qlik-Sense-Set-analysis-number-range/m-p/1603460#M44666 <P>I agree that the expression looks OK. How about your data model? Is the CustomerId a key field?</P><P>If it is - doing a count on it will give you wrong results....</P> Thu, 18 Jul 2019 05:52:53 GMT petter 2019-07-18T05:52:53Z https://community.qlik.com/t5/App-Development/Qlik-Sense-Set-analysis-number-range/m-p/1603428#M44664 <P>Hi,</P><P>I need to create a measure to count customers who aged between 10 and 50 using set analysis, here's my script:</P><P>Count({$&lt;Age={"&gt;10&lt;50"}&gt;}distinct(CustomerId))</P><P>The script looks ok, however the result I get is the total&nbsp; number of customers, not those who aged 10-50.Can someone tell me what's wrong?Thanks a lot!</P> Mon, 20 Dec 2021 21:38:40 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Set-analysis-number-range/m-p/1603428#M44664 aroyi 2021-12-20T21:38:40Z https://community.qlik.com/t5/App-Development/Qlik-Sense-Set-analysis-number-range/m-p/1603460#M44666 <P>I agree that the expression looks OK. How about your data model? Is the CustomerId a key field?</P><P>If it is - doing a count on it will give you wrong results....</P> Thu, 18 Jul 2019 05:52:53 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Set-analysis-number-range/m-p/1603460#M44666 petter 2019-07-18T05:52:53Z