topic Re: Pivot table column hide in QlikView

Pivot table column hide

Wed, 23 Oct 2013 05:45:50 GMT

Please advice how to hide a column in pivot table if the value is null

Re: Pivot table column hide

Gysbert_Wassenaar — Wed, 23 Oct 2013 06:22:07 GMT

If you're talking about the column of an expression that is shown for each value of a horizontal dimension then that's not possible. The expression column will always be shown for each dimension value. You can not hide it for one dimension value and show it for another.

Re: Pivot table column hide

Wed, 23 Oct 2013 06:29:29 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 column hide

Wed, 23 Oct 2013 06:33:13 GMT

Hi,

Could you please explain what could be the expected result from above input data?

Re: Pivot table column hide

Fri, 17 Jan 2014 09:24:32 GMT

hi Rajkumar,

please elaborate what exactly you want, so that it can be understood.

Re: Pivot table column hide

Fri, 17 Jan 2014 14:14:44 GMT

Hi Raj, you can't hide one cell value for Measure1.

If you want hide the entire Row if Dimension3='N' then use calculated dimension for Dimension3 like below:

IF(Dimension3='Y' , Dimension3 , Null()) and check the Suppress Null Values option.

If you want hide only Measure1 cell value when the Dimension3 is N then use the Expression for Measure1 like below:

IF(Dimension3='N' , ' ' , Your Actual Expression )

Here we are escaping the calculation for Measure1 with space if Dimension3 = 'N'

topic Re: Pivot table column hide in QlikView

Pivot table column hide

Re: Pivot table column hide

Re: Pivot table column hide

Dimension 1

Dimension 2

Measure 1

Re: Pivot table column hide

Re: Pivot table column hide

Re: Pivot table column hide