Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Pivot table column hide

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

Tags (4)
5 Replies

Re: Pivot table column hide

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Pivot table column hide

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.

Not applicable

Re: Pivot table column hide

Hi,

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

Not applicable

Re: Pivot table column hide

hi Rajkumar,

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

Not applicable

Re: Pivot table column hide

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'

Community Browser