Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Pivot table Hide column based on dimension value

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
A10-11-2013Y1015
B11-11-2013Y570
C12-11-2013N3015

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.

2 Replies
sushil353
Honored Contributor II

Re: Pivot table Hide column based on dimension value

in your dimensions

use calculated dimension

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

check the option supress when value is null.

HTH

Sushil

Not applicable

Re: Pivot table Hide column based on dimension value

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