Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to tell the chart I want values > a #?

I've searched high and low in the documentation and can't find the proper format to exclude values from a chart expression....

I want the sum of a field but only if the value is greater than 6. Here is the expression I've used to get the value if it equals 6, but the <> or > doesn't work...

sum({$AgeMos={'6'}>}NumTickets)

Thank you,

Sarah

2 Replies
johnw
Champion III
Champion III

Probably this?

sum({<AgeMos={">6"}>} NumTickets)

Not applicable
Author

Thank you, it worked like a charm.

Sarah