topic Eliminate column label in pivot table in QlikView

Eliminate column label in pivot table

Mon, 25 May 2015 06:04:42 GMT

Hi,

I have the following pivot table as attached.

The problem is when the table extracted to excel I get one empty column with label Date.

Is it possible to delete this label together with the empty column from the model?

I tried not to mark "label" in dimensions , but it is marked in default and can't be unmarked.

Please help.

Thanks,

Inna.

Re: Eliminate column label in pivot table

pokassov — Mon, 25 May 2015 07:04:25 GMT

Hello!

You can write backspace in the lable and make the column shorter, however, you can't hide the column.

Re: Eliminate column label in pivot table

Gysbert_Wassenaar — Mon, 25 May 2015 07:52:40 GMT

There's no way to prevent that column from being exported to excel. If this is very important to you then you can try coding a macro to delete the column from excel after exporting the table. Or if you have a small number of date columns then you can try using a straight table with expressions for each date column instead of using a pivot table.