Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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