Discussion Board for collaboration related to QlikView App Development.
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.
Can u attach the sample QVW file.
Ok With Attachments.
Please any body can help!!!!
I have tried below Macro but it hide/disable all second expression.
Any Idea to restrict particular month?
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
expr.Enable = FALSE 'Disable Second expression
Replace your variance expression by If(Left(Mnth,3)=Month(Today()),<Your_variance_expression>)
Then Select "Suppress Zero Values" in Presentation.
I have done as suggested but I can't get rid of this -(Hyphen). see my expression..