topic Re: Hide Column/Expression in Pivot table in QlikView

Hide Column/Expression in Pivot table

Wed, 16 Apr 2014 09:31:25 GMT

Dear all,

Please see below Pivot table...

I want a Variance only for Current Month (Like April-March).

How to hide other months Columns?

I know we can Hide in Straight Table but some what reason I want only in Pivot table.

Please see attached excel and qvw file as sample data.

Regards

Vinay

Wed, 16 Apr 2014 09:35:03 GMT

Can u attach the sample QVW file.

Wed, 16 Apr 2014 09:39:33 GMT

Ok With Attachments.

Wed, 16 Apr 2014 11:11:04 GMT

Please any body can help!!!!

I have tried below Macro but it hide/disable all second expression.

Any Idea to restrict particular month?

SUB EnableExp1

SET chart = ActiveDocument.GetSheetObject("CH01")

SET cp = chart.GetProperties

SET expr = cp.Expressions.Item(1).Item(0).Data.ExpressionData

expr.Enable = TRUE 'Enable Second expression

chart.SetProperties cp

END SUB

SUB DisableExp1

SET chart = ActiveDocument.GetSheetObject("CH01")

SET cp = chart.GetProperties

SET expr = cp.Expressions.Item(1).Item(0).Data.ExpressionData

expr.Enable = FALSE 'Disable Second expression

chart.SetProperties cp

END SUB

anbu1984 — Wed, 16 Apr 2014 13:09:22 GMT

Replace your variance expression by If(Left(Mnth,3)=Month(Today()),<Your_variance_expression>)

Then Select "Suppress Zero Values" in Presentation.

Wed, 16 Apr 2014 13:38:58 GMT

Hi Anbu,

I have done as suggested but I can't get rid of this -(Hyphen). see my expression..

if(Left(Mnth,3)=Month(Today()),sum(Sales)-before(sum(Sales)))

Thanks

Vinay