Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

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
MVP
MVP

Re: Modifier and Aggregation question

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

3 Replies
MVP
MVP

Re: Modifier and Aggregation question

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

homersimpson
Contributor II

Re: Modifier and Aggregation question

Hi Sunny,

thanks, it runs :-)

regards,

Fritz

MVP
MVP

Re: Modifier and Aggregation question

Awesome