Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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,