How to suppress Zero Value Rows in a pivot table

Fri, 22 Oct 2010 15:14:46 GMT

I have a pivot table, which calculates a number of expressions, and performs different calculations depending on the Key Performance Indicator that the pivot table is grouping by. It works fine, but one of the dimensions that I want to add to the table surrounds the cost area for the P&L the table concentrates on... there are a lot of these and I only want the table to show a row if the cost area has a value. At the minute it is showing all the rows that have zero values.

Expanded

My question is how can i suppress the rows where the expression values are zero. I'm guessing I need a calculated dimension, i've tried onel along the lines of: IF([Actual] <> 0, [GL Group]) but with little success. Can anyone point me in the right direction?

Thanks,

Matt

How to suppress Zero Value Rows in a pivot table

edu_oliveira — Fri, 22 Oct 2010 16:08:28 GMT

Hi Matt.

Try this....

In your Pivot Table, select in a sheet "Dimensions" the option "Supress when Values is null' for all fields, and in a sheet "Expressions" alter the calculation for:

If(

[your calculation]<>0,

[your calculation],

null()

)

Regards.

topic How to suppress Zero Value Rows in a pivot table in QlikView

How to suppress Zero Value Rows in a pivot table

How to suppress Zero Value Rows in a pivot table