topic How to Hide this column in pivot table in QlikView

How to Hide this column in pivot table

Anonymous — Wed, 30 Jan 2013 14:52:54 GMT

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

Re: How to Hide this column in pivot table

Anonymous — Wed, 30 Jan 2013 14:55:10 GMT

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

Re: How to Hide this column in pivot table

Gysbert_Wassenaar — Wed, 30 Jan 2013 14:57:05 GMT

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()))

)

Re: How to Hide this column in pivot table

Anonymous — Wed, 30 Jan 2013 15:01:55 GMT

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