Discussion Board for collaboration on QlikView Layout & Visualizations.
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 :
I would export to excel this table :
(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
Go to Solution.
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.
Create hidden pivot without 'B' for export purposes.
I 've used the first option (macro)
it's work perfectly