Discussion Board for collaboration on Qlik NPrinting.
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?
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
Thanks a lot Sunny. I was trying to control everything on measure 3 before. This worked perfectly.