Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

srikanthsri1
Valued Contributor

How to Hide this column in pivot table

HI

I just want to hide a column (expression ) where the values are null  and i'm uisng version  QV 10

please see the attached file

3 Replies
srikanthsri1
Valued Contributor

Re: How to Hide this column in pivot table

i want ot hide the YE 2012 Statutory column where all the values are nulls

MVP & Luminary
MVP & Luminary

Re: How to Hide this column in pivot table

I'm afraid thats not possible. The expressions will be shown for each value of COST TYPE. Even if expression returns only nulls for all rows. You could try combining your two expressions into one.

if(COST_TYPE='YE 2012',

     Sum(ELEMENT_ITEM_COST)

     Sum( if(COST_TYPE like 'Frozen',ELEMENT_ITEM_COST, null())) - Sum( if(COST_SUB_ELEMENT like 'MTP',ELEMENT_ITEM_COST, Null()))

)


talk is cheap, supply exceeds demand
srikanthsri1
Valued Contributor

Re: How to Hide this column in pivot table

you are right .. even  i felt the same .....but at end user point that doesn't make any sense to show a null values column...

Anyway  just want to give it a try for any workaround suggestion...

Thanks for your reply