topic Hiding rows with zero/null values in Qliksense table in Qlik NPrinting

Hiding rows with zero/null values in Qliksense table

rsdhavle — Tue, 12 May 2020 11:54:09 GMT

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

Re: Hiding rows with zero/null values in Qliksense table

sunny_talwar — Tue, 12 May 2020 12:29:57 GMT

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))

Re: Hiding rows with zero/null values in Qliksense table

rsdhavle — Tue, 12 May 2020 13:38:24 GMT

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