Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Suppress Zero Value Column in Pivot

Hi all,

I have one pivot table that contains the customer and year dimension. In the expression, I have current year and previous year sales. But when I put the year dimension under the expression, the non-related year will still be displayed, but all values are zero. How can I suppress this?

Attached is the sample scenerio. For example, when 2008 is selected, 2007 shouldn't be shown in the Current Year column. Same for Previous Year (2008 shouldn't be shown).

edit: The time dimension must be drillable.

2 Replies
Not applicable

Re: Suppress Zero Value Column in Pivot

Hi,

   it is because of your "Year" dimension in your drill group.If you removed your "Year" then you will not get any issues.I have attached the appln here.

-Jai

Not applicable

Re: Suppress Zero Value Column in Pivot

Hi Jai,

Sorry, I forgot to mention that the time dimension need to have a drill down option. So, removing the year will remove the drill down function.