Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Export Qlikview objects to multiple Excel sheet

jagan
Not applicable

Export Qlikview objects to multiple Excel sheet

Attached Qlikview file helps in exporting Qlikview object to multiple sheets in Excel file.

Regards,

Jagan.

Attachments
Comments
jelly_gvm
Not applicable

Hi Jagan,

Very nice post, it is very helpful for me...

Thanks

Regards,

Jelly.

Not applicable

Hello,

I've just found what I'm looking for with your attached file

Thanks a lot. It is very helpful for me.

Regards

Gregory

Not applicable

Hi Jagan!

cool post,

question if i wish to populate the pivot table with row values, is this possible to amend in the macro?

i can get this functionality with right click and export to excel in Qlikview but not with the provided macro.


see attached picture for how i am looking for the file to be produced.

Total Rows.png

elena888
Not applicable

Hi Jagan,

very nice

I have a question for you.

I tried to export some objects with your macro with my client version and it works perfectly!

But when I deploy the application on Access Point and try to export, nothing happens

I have already checked that these options are set in the management console:

- System>Setup>QVS>Security: Allow unsafe macro execution on server

- System>Setup>QVS>Security: Allow macro execution on server

- System>Setup>QVS>Document: Allow print and export to excel

Can you help me?

Thanks a lot,

Elena

shohamgodel
Not applicable

Hi Elena,

I am pretty sure that Access Point does not allow Macros to run.

jkampmeijer
Not applicable

Great!

Just what I was looking for.

A help to export multiple objects to Excel.

Thanks.

kkkumar82
Not applicable

Hi jagan,

Nice post on exporting , I came to know that exporting to excel is having limitation of 65000 rows but is there a way (either by macros) to achieve this, please suggest , if any.

Thanks

Kiran Kumar

Not applicable

Hi Elena

Did this work for you on Access Point now?

elena888
Not applicable

Hi!

No, it didn't.

KR

Elena

Not applicable

I had the same problem once, then i had to download Internet Explorer Plugin. then it worked fine for me.

did you try that option?

Version history
Revision #:
1 of 1
Last update:
‎03-07-2013 09:55 AM
Updated by: