Export Charts based on variables into excel or PDF

[#1]

Hi community,

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

[#2]

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

[#3]

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

[#4]

Check below document:

VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Valu...

[#5]

Hi Dathu,

Thanks for re post.

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

~Walter

[#6]

curtChamps‌ jtg‌

Hello Sir,

Loop Charts and Field Values - Excel Export Macro

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

\\