Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Open chart as an image

Hi people, i would like to know if there is a way to export a chart into an image, but i dont want to export to a folder only open in paint or power point or another picture viewer.

could be using macro or something like this?

i attached an example , i have to export to excel(i done it) and i have to export a chart as jpg or png or another format

thank you a lot

Fernando

Tags (4)
3 Replies
MVP
MVP

Re: Open chart as an image

Sub PrintCurrentSheet

Set objWord = CreateObject("Word.Application")

objWord.Visible = True

Set objDoc = objWord.Documents.Add

Const wdOrientLandscape = 1

objDoc.PageSetup.Orientation = wdOrientLandscape

ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard

objWord.Selection.Paste

'Const wdAlignParagraphCenter = 1

'objDoc.Paragraphs(1).Alignment = wdAlignParagraphCenter

'objDoc.PrintOut()

'DO WHILE objWord.BackgroundPrintingStatus > 0

'LOOP

'objWord.Quit wdDoNotSaveChanges

'Set objWord = Nothing

'Set objDoc = Nothing

END SUB

Partner
Partner

Re: Open chart as an image

Thank you tresesco,  but works ok in desktop mode but not in full browser ajax could be?

is there any way to export behind the acces point?

MVP
MVP

Re: Open chart as an image

Unfortunately macros won't work on ajax.