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: 
U_Waqar
Contributor II
Contributor II

Only show values >= 100000 and <=-100000

Hi Experts,

I am trying to show only those values which are greater than equal to 100000 and less than equal to -100000 using following measure:
if((Column(4) + Column(3) - Column(2)) >=100000 or (Column(4) + Column(3) - Column(2)) <= -100000, (Column(4) + Column(3) - Column(2)),Null())
Above mentioned measure is calculating based on other columns in Table Report.
Getting following result even after checking Suppress Zero Values and Suppress Missing from Presentation tab and from Dimension tab Suppress when value is null for all dimensions.

U_Waqar_0-1655800830941.png

If above scenario doesn't we can also show values based on one dimension "CLAIMID".

Please suggest.

Thanks 

 

 

 

Labels (2)
1 Reply
Or
MVP
MVP

This approach won't work because, presumably, columns 2, 3, and 4 have non-null / non-zero values. If you remove those columns entirely and replace the column references with the underlying formulas, you should be able to use suppress zero / null. Otherwise, you could try using Dimension Limits settings, but this would require that this column be first in the measure order.