Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Hiding rows with zero/null values in Qliksense table

I have below scenario. I want to show only rows in the table with non zero values where the difference is greater that or less than zero. How can i achieve this in Qliksense table? 

 

NameMeasure 1Measure2 Difference
A550
B1082
C330
Labels (2)
1 Solution

Accepted Solutions
Highlighted

Just make sure that Measure 1 and Measure 2 only display values when Difference is not 0. For example, let's say that Measure 1 and Measure 2 look like this

Measure1 -> Sum(Measure1)
Measure2 -> Sum(Measure2)

Change them to be

Measure1 -> If(Sum(Measure1) <> Sum(Measure2), Sum(Measure1))
Measure2 -> If(Sum(Measure1) <> Sum(Measure2), Sum(Measure2))

View solution in original post

2 Replies
Highlighted

Just make sure that Measure 1 and Measure 2 only display values when Difference is not 0. For example, let's say that Measure 1 and Measure 2 look like this

Measure1 -> Sum(Measure1)
Measure2 -> Sum(Measure2)

Change them to be

Measure1 -> If(Sum(Measure1) <> Sum(Measure2), Sum(Measure1))
Measure2 -> If(Sum(Measure1) <> Sum(Measure2), Sum(Measure2))

View solution in original post

Highlighted
Creator II
Creator II

Thanks a lot Sunny. I was trying to control everything on measure 3 before. This worked perfectly.