Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Export complete chart to jpg

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

5 Replies
Highlighted
Partner
Partner

Re: Export complete chart to jpg

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

Highlighted
Contributor II
Contributor II

Re: Export complete chart to jpg

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

Highlighted
Partner
Partner

Re: Export complete chart to jpg

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

Highlighted
Master II
Master II

Re: Export complete chart to jpg

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.

Learning never stops.
Highlighted
Contributor II
Contributor II

Re: Export complete chart to jpg

Hi Kamal,

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

Regards,

Carel