topic Re: How to export just a part of a pivot table columns to Excel in QlikView

How to export just a part of a pivot table columns to Excel

Mon, 17 Sep 2012 12:46:29 GMT

Hi,

I work on QV9, i would like to know how can i export a part of a pivot table?

For example, i have the following pivot table :

A	B	date1	date2	date3
xxxx	tttt	uuuu	iii	ddd
yyyy	tttt	uuuu	iii	ddd
zzzz	tttt	uuuu	iii	ddd

I would export to excel this table :

A	date1	date2	date3
xxxx	uuuu	iii	ddd
yyyy	uuuu	iii	ddd
zzzz	uuuu	iii	ddd

(the same pivot table than the up but without the second column)

the B column is needed in "presentation" (user interface) but not in the export that why i want to supress it from the export

Thanks

Re: How to export just a part of a pivot table columns to Excel

Anonymous — Mon, 17 Sep 2012 14:38:45 GMT

It can be done with a macro. Create a button, attach macro to it. Two options:

1. Use a macro that copies your table, and deletes 2nd coulmn. Requires system access.

2. Create a copy of ypur table which doesn't have column B. Keep it on a hidden sheet. Macro only need to send this hidden table to excel. This is much simpler, no need for system access.

Regards,

Michael

Re: How to export just a part of a pivot table columns to Excel

whiteline — Mon, 17 Sep 2012 14:40:10 GMT

Create hidden pivot without 'B' for export purposes.

Re: How to export just a part of a pivot table columns to Excel

Mon, 17 Sep 2012 16:04:17 GMT

Thank you!

I 've used the first option (macro)

it's work perfectly

Regards,

Amine