Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table column hide

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

5 Replies
Gysbert_Wassenaar

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
Author

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
Author

Hi,

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

Not applicable
Author

hi Rajkumar,

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

Not applicable
Author

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'