topic Loading images using a macro in QlikView

Loading images using a macro

Wed, 17 Aug 2011 09:43:22 GMT

Hi Everyone,

I'm fairly new to qlikview and with one project under my belt I'm looking at a new one which is a lot more challenging.

Basically the document will need to retrieve images from a file store on the network based on the criteria set in the list boxes. I can't load the images into the document as there could potentially be thousands of images. I've started playing around to prove this can be done and decided that a macro is the only approach. So far I can click on a value in a listbox and then push a button, this triggers a macro which goes and retrieives the image and displays it in a container for me which is great. I can also do this for multiple images as well now, but I have 2 problems...

1. I don't know the syntax to set the Image Strech to Keep Aspect (cant seem to find it anywhere for Foreground image

2. The 2nd, 3rd pics that I load are very blurry and lose quality, if I load the images without a container the quality is perfect

Below is the Macro I have so far:

sub OpenPics_Cont

IMG_PATH = "C:\Users\Public\Pictures\Sample Pictures\"

Set ContainerObj = ActiveDocument.Sheets("Main").CreateContainer

set ContProp=ContainerObj.GetProperties

set LB = ActiveDocument.GetSHeetObject("LB01")

pg=LB.GetPossibleValues

for i=lbound(pg) to ubound(pg)

set mytext=ActiveDocument.ActiveSheet.CreateTextObject

prop=mytext.GetProperties

prop.Layout.ImageRepresentation.Presentation = 1

prop.Layout.Text.v = "='" & IMG_PATH & pg(i) & ".jpg'"

mytext.SetProperties prop

ContProp.ContainedObjects.Add

ContProp.SingleObjectMode=1

ContProp.SingleObjectStyle=1

ContProp.ShowObjectTypeIcons=true

ContProp.ContainedObjects.Item(i).Id =prop.Layout.Frame.ObjectId

ContProp.ContainedObjects.Item(i).Text.v = pg(i)

ContainerObj.SetProperties ContProp

mytext.close

end sub

Does anyone have any idea's how I might be able to adjust the aspect of the image and why the image quality is so bad.

Re: Loading images using a macro

Wed, 17 Aug 2011 17:18:13 GMT

Hi,

Let's try this for image stretching

sub Stretch

set bu=ActiveDocument.GetSheetObject("BU01")

set prop=bu.GetProperties

prop.BkImageSettings.ImageStyle.StretchMode=1 'fill

bu.SetProperties prop

end sub

Let me know it works or not

Regards...

Re: Loading images using a macro

isaiah82 — Wed, 17 Aug 2011 17:52:16 GMT

Have you looked into the INFO functionality built in to QV? This allows you to link external files to a field value. Check the help file for the topic "Info" -Isaiah

Re: Loading images using a macro

Thu, 18 Aug 2011 14:03:28 GMT

@ravikumar_ajzaas - no this didnt work, Im beginning to wonder whether the property is available through the APi to stretch the image for a foreground picture.

I guess the alternative is to display a link to the image which will open in a browser page or something but I'd prefer to open the Image in qlikview.

Any suggestions?

Re: Loading images using a macro

Thu, 18 Aug 2011 14:06:42 GMT

@Isiah Weed - I didnt want to use this functionality, wouldnt this make a copy of the image and store it in the qlikview document, maybe I misunderstood how this works? The document is likely to be reloaded twice/thrice a day and will the amount of data will get large quite rapidly.

Re: Loading images using a macro

isaiah82 — Thu, 18 Aug 2011 14:14:46 GMT

With INFO LOAD you only embed the images in the QVW if you use the BUNDLE prefix. "Regular" INFO LOAD links to the file externally and it is only opened when called. I have the same issue as you; I would never be able to embed all of the images into my QVW for size constraints. Try the info load (no bundle) in a small test file and I think you'll be presently surprised. -Isaiah

Re: Loading images using a macro

Thu, 18 Aug 2011 17:05:40 GMT

Thanks Isaiah, I'll give this a try with the example I already have. I'll let you know how I get on with this.

Loading images using a macro

Tue, 06 Sep 2011 11:46:31 GMT

Just got back to this now... I tried the info load for the pictures and it works. Thanks a lot. Though it appears Im restricted to viewing one image at a time in a textbox. Which is no big deal the user can see the possible images related to the their criteria in the picture listbox and click each one as they wish, but oout of interest is it possible to view multiple images in multiple textboxes without the use of macros?

Loading images using a macro

isaiah82 — Tue, 06 Sep 2011 12:59:33 GMT

When you say text box I assume you mean a popup window (e.g. you've got a button with action = "Show Information"?) Or are you actually showing the image inside of a textbox? Moot point though really; I don't think you'll be able to cycle through the possible values without a macro, although that's not to completely say something couldn't be done.

Instead you can create a table box (or straight/pivot table) and adding your field with Info as a dimension. Then pick "Info as Image" in Advanced Field Settings (this is on the Presentation tab in table box properties.) Remember to wrap text a few lines. -Isaiah

Loading images using a macro

Tue, 06 Sep 2011 13:15:19 GMT

Yes i meant pop up boxes, opened by a macro. I'll give the table box method a try first though.

Loading images using a macro

Tue, 06 Sep 2011 16:22:06 GMT

I can create a largish table box set the size and disable move/size then it will show 1 image and the scrollbar will be available for instances of multiple images.

That will work great.

Thank you for all your help Isaiah.