Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
SunilChauhan
Champion
Champion

presentation supress zero value

and in dimension supress null value

hope this helps

Sunil Chauhan
Not applicable
Author

Hello Sunil Chauhan,

I tried both but it didn't work.

Thanks voor the responds.

Greetz,

Ralph