topic Export Trellis-chart as images in QlikView

Export Trellis-chart as images

Wed, 15 Dec 2010 17:41:44 GMT

Hi out there,

i'm exporting images via .net application from qlikview to my harddrive. This works very well for all images despite the trellis charts. It always says me in german "Zu wenige Formeln" / "To less formulas".

I'm using the WriteToFile function of the image-object. If I doing this per hand with right click and export it works and the image is as it should be.

Maybe someone has also this problem? Seems like a bug in the api.

Christoph

Export Trellis-chart as images

Anonymous — Thu, 16 Dec 2010 12:40:33 GMT

Suggestion:

Instead of WriteToFile you can try and use ExportBitmapToFile:

I tried the macro below and it worked for me:

sub SaveBitmap

set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportBitmapToFile "C:\CH01.jpg"

end sub

Let me know if it also works for you.

Export Trellis-chart as images

Thu, 16 Dec 2010 13:56:47 GMT

Hi,

ok, this workaround is a possibilty.
The problem with this solution is that there is no way how I can find out if this chart is an trellis-chart.
GetObjectType says me it's an type 12 / bar-chart. Also images generated per ExportBitmapToFile are bitmaps and not .png's.

I have a list of id's which are all getting exported. But because of the problem above I cant figure how to export (ExportBitmapToFile or WriteToFile).
I dont want to have a lot of .bmp when some of them could be .png and waste diskspace.