Announcements
cancel
Showing results for
Did you mean:
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?

 Name Measure 1 Measure2 Difference A 5 5 0 B 10 8 2 C 3 3 0
Labels (2)

• ### Qlik Sense

1 Solution

Accepted Solutions
MVP

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))``````
2 Replies
MVP

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))``````
Creator II
Author

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

Community Browser