topic Export To Excel - Pivot Chart - Macro in QlikView

Export To Excel - Pivot Chart - Macro

sathishkumar_go — Tue, 29 Mar 2016 16:45:49 GMT

Hi All,

I have written a macro for exporting to excel (Pivot chart) and its working fine.

Just want to know, How to remove grouping while exporting to excel in macro?

-Sathish

Re: Export To Excel - Pivot Chart - Macro

sinanozdemir — Tue, 29 Mar 2016 18:03:52 GMT

Maybe like the below:

group = ActiveDocument.GetGroups

group(0).RemoveField 2 -> replace 2 with the field that you want to remove from the pivot table.

Hope this helps.

Re: Export To Excel - Pivot Chart - Macro

sathishkumar_go — Tue, 29 Mar 2016 18:21:40 GMT

Hi Sinan,

Thanks for your reply. Let me explain you my requirement clearly.

I have the pivot chart through macro I am exporting to excel the datas of pivot chart.

Example: After exporting the data into excel

ProductName

Producttype

Value

Type1

Type2

100

I don't want merged cells. what I am expecting,

ProductName	Producttype	Value
A	Type1	50
A	Type2	100

Re: Export To Excel - Pivot Chart - Macro

sinanozdemir — Tue, 29 Mar 2016 18:31:23 GMT

Hey Sathish,

I don't get that merged cell problem when I export a pivot table via a macro or the export button on the pivot table. Would you post your macro by any chance?