Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
aroyi
Contributor III
Contributor III

Qlik Sense-Set analysis-number range

Hi,

I need to create a measure to count customers who aged between 10 and 50 using set analysis, here's my script:

Count({$<Age={">10<50"}>}distinct(CustomerId))

The script looks ok, however the result I get is the total  number of customers, not those who aged 10-50.Can someone tell me what's wrong?Thanks a lot!

Labels (1)
1 Reply
petter
Partner - Champion III
Partner - Champion III

I agree that the expression looks OK. How about your data model? Is the CustomerId a key field?

If it is - doing a count on it will give you wrong results....