topic Suppress value in Pivot table in QlikView

Suppress value in Pivot table

Wed, 18 Apr 2012 09:59:36 GMT

Hello,

In the attached QLV datafile I want to suppress all the "0" (null) or ( -) value's in the "PIVOT" table.

I only want to see the rows where a score is filled in (last colomn "Rapportcijfer")

See attach Word "example Report".

Question 2:

How can I connect the average of the "rapportcijfers" in the Pivot table with the Gauge chart.

Thanks,

Ralph

SunilChauhan — Wed, 18 Apr 2012 10:04:44 GMT

presentation supress zero value

and in dimension supress null value

hope this helps

Wed, 18 Apr 2012 10:32:57 GMT

Hello Sunil Chauhan,

I tried both but it didn't work.

Thanks voor the responds.

Greetz,

Ralph