topic Re: Issue with a pivot table in QlikView

Issue with a pivot table

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

I've managed to get a pivot table with all the data I need but it requires some extra formatting.
Long story short: how can I get rid of the "ambiente" column without affecting the data in my other columns? I need the table to have the following headers:

"cognome" "nome" "ambiente" "amb asl" "amb priv" "ospedale" "osp. DM" "occasionali" "condivisi" "totale", but if I remove the "ambiente" column, there won't be any data in any other columns except "cognome" and "nome"(which are taken from the database).

I probably have to use the aggregate function but can anyone help me with it?

Re: Issue with a pivot table

sunny_talwar — Mon, 18 Dec 2017 16:52:50 GMT

So you are looking for a way to show this chart without adding ambiente as a dimension?

May be use a one time macro to suppress the width of ambiente column to 0?

Pivot Column Width to Zero

Re: Issue with a pivot table

Anonymous — Wed, 20 Dec 2017 07:21:45 GMT

Thanks!