Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
rsdhavle
Creator III
Creator III

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
sunny_talwar

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
sunny_talwar

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))
rsdhavle
Creator III
Creator III
Author

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