Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Avg where >= and <=

Hi,

i want to make an expression like this:

Avg({1<price={">=12"},price={"<=18"}>}sales)

i try this, too. But the avg number is not correct.

Avg({1<price={">=12" AND "<=18"}>}sales)

Avg({1<price={">=12","<=18"}>}sales)


Is one of these expressions correct?


regards,

sam

1 Solution

Accepted Solutions
MVP
MVP

Re: Avg where >= and <=

Avg({1<price={">=12<=18"}>}sales)

1 Reply
MVP
MVP

Re: Avg where >= and <=

Avg({1<price={">=12<=18"}>}sales)