topic Re: Export Charts based on variables into excel or PDF in QlikView

Export Charts based on variables into excel or PDF

Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

Is it possible to export the different charts which are stored in a variable into excel or PDF using macro ?

Fri, 08 Apr 2016 20:56:07 GMT

I believe, you can change the Macro Name based on Your Variable Value

Action --> External --> Run Macro

Write Expression: IF('$(vExportExcel'='Y', ExportToExcelMacro , ExportToPDFMacro)

If this is not working, create two buttons based on your variable value, always show only one button either ExportToExcelMacro or ExportToPDFMacro

Fri, 08 Apr 2016 21:04:52 GMT

Hi Dathu,

Thanks for the reply.

I have stored all the Sheet objects into a variable and wanted to print them based on the user slection.

This variable pulls out the user selected chart. Now I want to export that chart into either excel or PDF.

I am new to Qlikview and not good at writing macro. Can you please explain me in detail.

thanks again

Sat, 09 Apr 2016 00:41:15 GMT

Check below document:

Mon, 11 Apr 2016 13:57:26 GMT

Hi Dathu,

Thanks for re post.

This Case is not similar to mine. I am trying to pull the chart to Excel.

~Walter

Mon, 11 Apr 2016 16:48:19 GMT

Hello Sir,

I found your article very useful, Now i am trying to implement the logic in exporting the chart stored in the Variable.

Can you help me in implementing this ??

Thanks in advance