topic Open chart as an image in QlikView

Open chart as an image

fkeuroglian — Tue, 01 Jul 2014 13:45:16 GMT

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

Re: Open chart as an image

tresB — Tue, 01 Jul 2014 14:06:26 GMT

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

Re: Open chart as an image

fkeuroglian — Tue, 01 Jul 2014 14:22:24 GMT

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?

Re: Open chart as an image

tresB — Wed, 02 Jul 2014 04:20:41 GMT

Unfortunately macros won't work on ajax.