Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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))
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))
Thanks a lot Sunny. I was trying to control everything on measure 3 before. This worked perfectly.