Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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 :

ABdate1date2date3
xxxxttttuuuuiiiddd
yyyyttttuuuuiiiddd
zzzzttttuuuuiiiddd

I would export to excel this table :

Adate1date2date3
xxxxuuuuiiiddd
yyyyuuuuiiiddd
zzzzuuuuiiiddd

(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

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

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

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

3 Replies
mov
Esteemed Contributor III

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

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

whiteline
Honored Contributor II

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

Create hidden pivot without 'B' for export purposes.

Not applicable

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

Thank you!

I 've used the first option (macro)

it's work perfectly

Regards,

Amine

Community Browser