topic Re: Pivot table automatically suppressing columns in QlikView

Pivot table automatically suppressing columns

ashishpalkar — Wed, 25 Nov 2020 16:16:04 GMT

Hi There

I have created Pivot table and its automatically suppressing columns when value of the column is Null or 0.

I want to still show users column Header and it should not suppress when become null. Any workaround?

I have tried with un-checking following

1. Suppress Zero-Values

2. Suppress Missing

Thanks in advance.

Re: Pivot table automatically suppressing columns

Anil_Babu_Samineni — Mon, 03 Jul 2017 14:03:09 GMT

You must play around with suppress option only. Don't disable that option and tick the check boxes. Will you provide screen shot of presentation tab?

Re: Pivot table automatically suppressing columns

MK_QSL — Mon, 03 Jul 2017 14:03:28 GMT

Select that particular field and tick Show All Values in Dimension tab

Now tick Suppress When Value is Null for all other dimensions

Go to Presentation tab

Untick Suppress Zero Values

Re: Pivot table automatically suppressing columns

avinashelite — Mon, 03 Jul 2017 14:05:37 GMT

Null value is coming from Dimension or the expression ?? if its from the expression the presentation tab option should work . if its from the dimension then un-check the suppress null in the dimension tab .

If your still facing the issue share the sample app

Re: Pivot table automatically suppressing columns

Anonymous — Mon, 03 Jul 2017 14:05:42 GMT

Hi Ashish ,

Did you checked the expression ? what exactly used in expression

please share sample data if possible

Re: Pivot table automatically suppressing columns

ashishpalkar — Mon, 03 Jul 2017 14:17:50 GMT

Hi Avinash

its coming from expressions. I am using expression as columns and they are suppressing.

Re: Pivot table automatically suppressing columns

MK_QSL — Mon, 03 Jul 2017 14:19:10 GMT

Check my suggestion, it should work.