Export complete chart to jpg

[Anonymous]

Hi,

I am exporting a chart to a jpg file with this Macro:

Sub ExpGeactiveerdAssortiment

GraphPath  = "C:\QlikView\Export\Assortiment\Geactiveerd assortiment\"

ActiveDocument.GetSheetObject( "CH11").ExportBitmapToFile GraphPath & "GeactiveerdAssortiment.jpg"

End sub

This is exporting a jpg of the chart. Only thing is it seems to make a screenshot of the chart and is not showing information for wich you must scroll in the chart.

Anyone any idea how to get the complete chart instead of only the visible part?

After the export to jpg i use a powershell script to add the jpg in to the body of an e-mail.

Regard,

Carel

[kamalqlik]

Hi @carel,

Exporting will lead to image as per Qlik Application only.

If you want to export full data than you have to extract in excel

Regards

@kamal

[Anonymous]

Hi Kamal,

Thanks for you response.

The problem is that there are images in my chart and i can not export them to Excel.

Regards,

Carel

[kamalqlik]

Hi What you can do,

You can make full size of chart and hide in the Qlikview application. Use that object or chart Id to be send as image .

Hope this help you.

Regards

Kamal

[pradosh_thakur]

I dont have much experience in Macro but manually you can do this may be write a macro for the below steps.

1: save the file

2: right click on the chart -> copy to clipboard->object

3: paste it in excel

4: copy any list box or filter you want to copywith the same process.

the chart will react to the filter selection in excel.

ps: ignore if this is not relevant to you.

[Anonymous]

Hi Kamal,

What do you mean with make a full size of the chart? And how do i do it?

Regards,

Carel