topic Re: Pivot table Hide column based on dimension value in QlikView

Pivot table Hide column based on dimension value

Wed, 23 Oct 2013 06:24:43 GMT

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.

Re: Pivot table Hide column based on dimension value

sushil353 — Wed, 23 Oct 2013 06:34:19 GMT

in your dimensions

use calculated dimension

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

check the option supress when value is null.

HTH

Sushil

Re: Pivot table Hide column based on dimension value

Wed, 23 Oct 2013 06:38:16 GMT

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

topic Re: Pivot table Hide column based on dimension value in QlikView

Pivot table Hide column based on dimension value

Dimension 1

Dimension 2

Measure 1

Re: Pivot table Hide column based on dimension value

Re: Pivot table Hide column based on dimension value