Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
New Contributor III

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

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

May be this

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

View solution in original post

2 Replies

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

May be this

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

View solution in original post

Highlighted
New Contributor III

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

It is working. Thank you Sunny