topic Re: Suppress Column in pivot table in QlikView

Suppress Column in pivot table

inescastelhano — Tue, 05 Apr 2016 12:56:23 GMT

Hi all,

I have the following pivot table, and I would like not to show the column "Total" when it has no data. For example, april and may has no data, so I would like to hide these columns. I have "Suppress when value is null" and "Suppress zero values" checked.

Any help would be appreciated.

Thanks in advance.

Cheers,

Inês

Re: Suppress Column in pivot table

Gysbert_Wassenaar — Tue, 05 Apr 2016 13:02:55 GMT

As you can see the Total column has values in jan and feb. That's the reason it will be shown for all months. You can't suppress it. It will always be shown for all the month values as long as there's at least one value for one month.

Re: Suppress Column in pivot table

amit_saini — Tue, 05 Apr 2016 13:02:55 GMT

Hi,

I think this is not possible in pivot table , but let's wait for experts suggestion.

Thanks,

Re: Suppress Column in pivot table

arthur_dom — Tue, 05 Apr 2016 13:06:16 GMT

You could do it by creating a big straight table. With 24 expressions ( 12 for total and 12 for total PY ), and on each expression create a conditional.

Re: Suppress Column in pivot table

krishnacbe — Tue, 05 Apr 2016 13:15:08 GMT

In pivot we can't hide columns. Try with Straight table.

Re: Suppress Column in pivot table

inescastelhano — Tue, 05 Apr 2016 13:49:26 GMT

So then can I hide the months which are after the current month? for example, not to show may, june, july, etc.

Re: Suppress Column in pivot table

arthur_dom — Tue, 05 Apr 2016 13:59:00 GMT

Yup, but that will depend on your conditional

Re: Suppress Column in pivot table

Gysbert_Wassenaar — Tue, 05 Apr 2016 14:09:25 GMT

That should be possible. You could simple select the months you want to see or change the expressions in your pivot table to exclude the months you don't want to see.