topic Re: Exporting all charts to excel simultaneously in QlikView

Exporting all charts to excel simultaneously

snehamahaveer — Fri, 11 Sep 2015 10:28:11 GMT

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.

Re: Exporting all charts to excel simultaneously

gautik92 — Fri, 11 Sep 2015 10:31:23 GMT

have a look at this

Re: Exporting all charts to excel simultaneously

snehamahaveer — Fri, 11 Sep 2015 11:00:32 GMT

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.

Re: Exporting all charts to excel simultaneously

gautik92 — Fri, 11 Sep 2015 11:02:18 GMT

ctrl+M and add a macro code click ok

Re: Exporting all charts to excel simultaneously

snehamahaveer — Fri, 11 Sep 2015 11:03:49 GMT

Awesome. Thank you.

Re: Exporting all charts to excel simultaneously

gautik92 — Fri, 11 Sep 2015 11:05:01 GMT

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

Re: Exporting all charts to excel simultaneously

qlikviewwizard — Fri, 11 Sep 2015 11:05:20 GMT

Hi Sneha,

Please check these threads. Hope this will help you.

Export two reports into 2 tabs of one excel

Useful Qlikview Macros

Re: Exporting all charts to excel simultaneously

visu12 — Thu, 11 May 2023 07:34:57 GMT

@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.