Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Supress Zero Values in Pivot Table

I got a question, how to supress Zero values in a Pivot table.
My Data Source looks like this:

DateSourceError 1Error 2Error 3Error 4Error 5Error 6Error 7Error 8Error 9
23.07.2010A68656710
23.07.2010B16391130

I generate a Standard Table and it looks like this:

error loading image

Here the same a a Pivot table:

error loading image

I used Source as Dimension and sum(Error 1), Sum(Error 2) ... Sum(Error 9) as Formula.
I tried to use the "supress zero" checkbox. That works only, if there are Zeros in every Formula (Error 1 - 9).
As far as there is a value greater zero in any of the formulas, the privot table is showing all 9 formulas.
Is there a Possibility to supress that?

Thanks for your help.

1 Solution

Accepted Solutions
Not applicable

Supress Zero Values in Pivot Table

Hi dj-kalle,

Please find the attached document for the reference.

I think this will help you .

Regards,

Ravi

View solution in original post

3 Replies
Not applicable

Supress Zero Values in Pivot Table

Hi dj-kalle,

Please find the attached document for the reference.

I think this will help you .

Regards,

Ravi

View solution in original post

Not applicable

Supress Zero Values in Pivot Table

Hi Ravi,

Thank you for your answer! Did i understand you right, that i have to change my data model, to bring my row titles (Source, Error 1 - Error 9) into one column?

Regards, Martin

Not applicable

Supress Zero Values in Pivot Table

Now its working: I created another table with "crosstable load" and joined it over an id to my original data. Then i created two dimensions like in Ravi´s Example. Now ist works and the zeros are supressed! Thanks a lot!