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

Modifier and Aggregation question

Hi,


i want to count all sales, where the average price is <=3. What syntax must i use?


This syntax is not correct:

Count(DISTINCT{<Avg(price)= {"<=3"}>} sales)


regards,

Fritz

1 Solution

Accepted Solutions
sunny_talwar

What is the field you are checking the Avg(Price) on?

Try this:

Count(DISTINCT {<IDField = {"=Avg(Price) <= 3"}>} sales)

Replace IDField with the field you are Avg(Price) on

View solution in original post

3 Replies
sunny_talwar

What is the field you are checking the Avg(Price) on?

Try this:

Count(DISTINCT {<IDField = {"=Avg(Price) <= 3"}>} sales)

Replace IDField with the field you are Avg(Price) on

Anonymous
Not applicable
Author

Hi Sunny,

thanks, it runs 🙂

regards,

Fritz

sunny_talwar

Awesome