Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Export chart as image using ExportBitmapToFile

Hi

I have a button which runs a small script using ExportBitmapToFile to create jpg image of a chart using the following:

ActiveDocument.GetSheetObject("CH64").ExportBitmapToFile  <filename.jpg>

This works perfectly if the chart is on the same sheet as the button.

However, I would like the button to be on a different sheet to the relevant chart.

Can anyone tell me what the command should be ?

Thanks

Richard

1 Reply
v_iyyappan
Specialist
Specialist

Hi,

You can get all sheetid from the below code. so you can mention get desired sheetid.

sub LoopSheet

for i = 0 to ActiveDocument.NoOfSheets - 1

set ss= ActiveDocument.GetSheet(i)

msgbox(ss.GetProperties.SheetId)

next

end sub

Hope its help,

Regards,