Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Suppress value in Pivot table

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

2 Replies
chauhans85
Esteemed Contributor

Suppress value in Pivot table

presentation supress zero value

and in dimension supress null value

hope this helps

Not applicable

Suppress value in Pivot table

Hello Sunil Chauhan,

I tried both but it didn't work.

Thanks voor the responds.

Greetz,

Ralph

Community Browser