Create an Excel with multiple tabs

[kris_vliegen]

Hi All,

We've a customer with fuelstations. Now he want's that Qliview (version 11 or 12) creates an Excel with the data of the payementtype(Columns) by month (row).

And every tab should have the data of 1 station.

Tab1 -> data of station 1, tab 2 -> data of station 2, ...

Is this possible via Qlikview?

Regards,

Kris

[lironbaram]

hi 

Qlik nprinting will do this easily for you 

you should check this out 

https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/Introduction/Introduction.htm

[avinashelite]

Using Qlikview load script its not possible , only way using Qlikview is you need to use macros .

Check this link 

https://community.qlik.com/t5/Qlik-Sense-App-Development/Storing-Data-into-Multiple-Tabs-in-an-Excel...

[Frank_Hartmann]

have alook at the attached qvw

hope this helps

[kris_vliegen]

Hi,

I found a macro that create's an excel with multiple tabs.

But it dosn't work on my access-point. Only in my desktop version. 

[kris_vliegen]

Hi Frank,

Tnaks for this QVW. This is  working in my deskotop but not in the accesspoint...

Regards,

Kris

[Brett_Bleess]

Kris, this is by design most likely given how you are attempting to run things.   You will have to use QV.exe /r option and run via External Task in Pulisher...

See the following Article for further help:

Publisher and Actions/Macros

Regards,
Brett