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

[Anonymous]

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.

[sunny_talwar · Accepted solution]

May be this

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

[Anonymous]

It is working. Thank you Sunny