topic Re: Generating Images (Gauges) in QlikView

Generating Images (Gauges)

Wed, 01 Aug 2012 07:21:16 GMT

I've figured out how to generate images for charts. The problem now is with Gauges, they generate an image per Gauge (which makes sense, because it's per objectID that I loop through to Export). The Gauges "loses" their label so makes it a bit difficult to figure out which is which.

I was wondering if there's a way to group these gauges so that when I export to bitmap through the macro, that the group of 4 gauges generates as ONE image?

Re: Generating Images (Gauges)

Wed, 01 Aug 2012 08:53:04 GMT

Maybe generating image of the Sheet might help.

Re: Generating Images (Gauges)

Wed, 01 Aug 2012 09:07:14 GMT

How would I be able to do/test that?

Re: Generating Images (Gauges)

Wed, 01 Aug 2012 09:12:08 GMT

sub SaveSheetImage

ActiveDocument.Sheets("Main").ExportBitmapToFile "C:\MyImage.bmp"

end sub

Re: Generating Images (Gauges)

Wed, 01 Aug 2012 09:21:54 GMT

That does help, but the image has a lot of white space, is there anyway to crop it to be as big as whatever is visible (so if the guages is 100px in height, not to show 100px + 600px of white space)

Re: Generating Images (Gauges)

Wed, 01 Aug 2012 09:29:04 GMT

That's a strictly VBA macro question. You can get better help on a VBA dedicated forum.

Re: Generating Images (Gauges)

Wed, 01 Aug 2012 09:37:36 GMT

Even though it might be a VBA Macro question, the reason why I asked it here is because I'm not sure if QlikView's object has like power point has:

.PictureFormat.CropLeft = 10 .PictureFormat.CropTop = 10 .PictureFormat.CropRight = 10 .PictureFormat.CropBottom = 10