topic Using a Macro Export to excel in QlikView

Using a Macro Export to excel

Thu, 17 Nov 2011 06:07:55 GMT

Good Morning All,

Using a macro I can export the QV pivot table to excel file its good but in my requirement is it should be as a pivot table as in Excel.

I have attached two outputs, the Test excel file is using a macro its exported and Test 1 is my orginal requirement.

Using a macro is it possbile, can any one help me on this...

Regards

Chriss

lironbaram — Thu, 17 Nov 2011 07:21:45 GMT

hei

the solution for your problem is to export the data you want but in strait table format

to specific file

then run a macro in the excel file that creates pivot table

i'll try the post an exmple later

Thu, 17 Nov 2011 07:31:05 GMT

hi,

thanks for your reply, thanks in advance for your example.

Regards

Chriss

Tue, 22 Nov 2011 13:40:58 GMT

Hi liron baram,

I am still waiting for your sample file, can you please attach me.

Regards

Chriss