Pivot table Hide column based on dimension value

[#1]

We need to hide a column dynamically based on dimension value using pivot table in QlikView 11

Example

Measure 2

Dimension 1	Dimension 2	Dimension 3	Measure 1	Measure 2
A	10-11-2013	Y	10	15
B	11-11-2013	Y	5	70
C	12-11-2013	N	30	15

When on pivoting Dimension-3 over the measures horizontally, system should show the measure 1 column when dimension-3 value is Y and should hide the measure 1 column when dimension-3 value is N.

Any suggestion is appreciated.

[sushil353]

in your dimensions

use calculated dimension

=if(Dimension3='Y',Dimension3,null())

check the option supress when value is null.

HTH

Sushil

[#3]

Thanks for your timely response.

But forget to mention that dimension 3 will have multiple values, in this case how to supress.

If we execute the below mention script then measure 2 will get disappear

use calculated dimension

=if(Dimension3='Y',Dimension3,null())