Exporting all charts to excel simultaneously

[snehamahaveer]

Hi Everyone, I am creating a report which previously was created manually in spreadsheet. Is it possible to export all the charts in a Qlikview dashboard by one click of a button to an excel spreadsheet?? If yes, that would be great. Could you please tell me how to achieve the same. Thanks in advance.

[gautik92 · Accepted solution]

have a look at this

[snehamahaveer]

Thanks Gowtham. Its what I wanted. Sorry I am being a pain, but how could I set up a macro in Qlikview. I have not used it before and I definitely find it useful.

[gautik92]

ctrl+M and add a macro code click ok

[snehamahaveer]

Awesome. Thank you.

[gautik92]

if you got the answer mark correct answer and close the thread

[qlikviewwizard]

Hi Sneha,

Please check these threads. Hope this will help you.

Export two reports into 2 tabs of one excel

Useful Qlikview Macros

[visu12]

@gautik92 - I want the same functionality in QlikSense (to download all charts in dashboard into different excels). Can you please share the code for Qlik Sense. Appreciate your help.