Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to count the number of id's if the price is less than 10?

Hi Team,

I have columns with id's, Price, Country. I need to count the number of id's with Price is less than 10. I tried with many different methods and failed. I am new to Qlikview and not understanding how to get this.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT {<Price = {'<10'}>} ID)

View solution in original post

2 Replies
sunny_talwar

May be this

Count(DISTINCT {<Price = {'<10'}>} ID)

Anonymous
Not applicable
Author

It is working. Thank you Sunny