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

Setting graph ranges

Hello,

I am having trouble creating a graph that will only display values about a certain range. I have a Company list and there avg rev.  ave rev is an expression. I only want to display ave revs above a certain value on my graph.   How can I do this? since it is am expression I cant write a dimension that will hide the zeros, or can?

Thank you

1 Reply
Not applicable
Author

try an IF condition.

IF(avg(revenue)>10,avg(revenue))

this will only show the average revenue, if its hihher than 10