topic Re: AW:Re: Update/Refresh Image in QlikView

Update/Refresh Image

Tue, 16 Nov 2010 13:55:24 GMT

Hi.

I have created a text-box containing a picture.

The problem is, that the original picture file has to be updated once a week.

My question is if there is a possibility to do this automaticaly.

Thank you for your help

Kind regards

Simon

Update/Refresh Image

vgutkovsky — Tue, 16 Nov 2010 21:44:25 GMT

Simon,

Take a look at the QlikView Reference Manual, page 205 (section 18.3). You can embed an image in a QlikView document and reference it using qmem:// syntax. You can then reload the image with the script.

Regards,

AW:Re: Update/Refresh Image

Wed, 17 Nov 2010 08:07:16 GMT

Dear Vlad.

I have checked the manual but it does only explain how to load something (arrows, smileys, etc.) from the internal files library.

What do you think would be the syntax for the image?

My picture is located at the following path within a subfolder of the qlikview document:

./gfx/demo.png

Regards

Simon

Re: AW:Re: Update/Refresh Image

Miguel_Angel_Baeyens — Wed, 17 Nov 2010 08:50:38 GMT

Hello Simon,

You have two possibilities here:

1.- Using the image as an external file (so you will need both QlikView document and image file) you will link this image to a field:

Data:
LOAD * INLINE [
ID, Cnt
Blue, 1
Red, 2]; 
Images:
INFO LOAD * INLINE [
ID, Imagen
Blue, help_blue.png
Red, hep_red.png];

2.- Embed those image files into QlikView document

Using the same script from paragraph 1, change INFO for BUNDLE, then you will refer to the image using:

='qmem://ID/Blue'

Hope this helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

AW:Re: AW:Re: Update/Refresh Image

Wed, 17 Nov 2010 09:31:13 GMT

Thank you for your replies.

This works fine 😄

Here is the complete script once more if someone has the same question:

Script:

Images:
BUNDLE LOAD * INLINE [
CustImg, Image
folder_1, folder_1.png
folder_2, folder_2.png
];

Text-Object
(representation as image):

='qmem://CustImg/folder_1'

Folder-Content:

embedded_image.qvw

folder_1.png

folder_2.png

Best regards

Simon

AW:Re: AW:Re: Update/Refresh Image

Tue, 07 Dec 2010 11:23:28 GMT

Now I want to get the information tested with an inline table from a csv-flatfile. Is there any possibility to do so?

Best regards
Simon

Update/Refresh Image

Mon, 22 Aug 2011 08:02:04 GMT

Thank you all for your suggestions, all sorted now! Bri.

Re: AW:Re: Update/Refresh Image

Mon, 11 Mar 2013 17:34:52 GMT

Are you sure this is correct and works on QV 11?

Tried a couple ways, both the way that Miguel and Skoenen indicated, the images do not appear in the text box.

Load script is below, alternate which version tried by commenting out, currently using Miguel method:

// sn method, doesn't seem to display in text box using : ='qmem://CustImg/acid3'

Images:

BUNDLE LOAD * INLINE [

CustImg, Image

acid3,acid3.png

browswermark,browswermark.png

];

// MAB method, doesn't seem to display in text box using : ='qmem://ID/Ad'

Data:

LOAD * INLINE [

ID, Cnt

Ad, 1

Bk, 2];

Images:

BUNDLE LOAD * INLINE [

ID, Imagen

Ad, acid3.png

Bk, browswermark.png];

// MAB method, doesn't seem to display in text box with image display using the following in text box : ='qmem://ID/Ad'

Re: AW:Re: Update/Refresh Image

Mon, 11 Mar 2013 19:00:37 GMT

Forget it, the example was perfect, Imade a simple stupid mistake.

Re: Update/Refresh Image

pennetzdorfer — Wed, 11 Sep 2013 09:59:17 GMT

Hey, thanks for sharing your script.

A question: in the Table Viewer i can see that the bundle load creates a new table $orphan_CustImg. Is that intended?

Regards,

Florian

Re: Update/Refresh Image

Wed, 27 Aug 2014 10:15:57 GMT

Can i know what's the fault you did as i'm now trying this example and it didn't work in QV11??

Re: Update/Refresh Image

Wed, 27 Aug 2014 10:18:11 GMT

i'm trying this example but it doesn't work with me

i'm using QV11

what could be the problem?

Re: Update/Refresh Image

Anil_Babu_Samineni — Wed, 06 Jul 2016 08:37:47 GMT

Miguel,

Is there any change to share the qvw, Please?

Looking good.

Re: Update/Refresh Image

Anonymous — Wed, 01 Nov 2017 10:16:39 GMT

Hi Simon,

I am trying to add custom smiley images for RAG ratings using expressions in the List Box object. I have edited your script based on my folder name and image name. I have tried to load the script but its saying '0 lines fetched' so i assume there are still some mistakes in my script. Could you please advise whether the below is correct or not?

Image name: fairface.png

Folder name: wcc IMAGES

Folder location: L:\ abc\wcc IMAGES

Script

Images:

BUNDLE LOAD * INLINE [

CustImg,

qmem://CustImg/abc\wcc IMAGES, fairface.png

];

Re: Update/Refresh Image

Anonymous — Thu, 02 Nov 2017 09:36:21 GMT

Hi,

Image name: fairface.png

Folder name: wcc IMAGES

Folder location: L:\ abc\wcc IMAGES

Script

Images:

BUNDLE LOAD * INLINE [

CustImg,

qmem://CustImg/abc\wcc IMAGES, fairface.png

];

Re: AW:Re: AW:Re: Update/Refresh Image

Bala_s — Wed, 04 Sep 2019 09:18:02 GMT

Hi,

Thanks for the script, it works perfectly in QlikView.

Can I achieve same in QlikSense ?

Thanks,

Bala

Re: AW:Re: Update/Refresh Image

Bala_s — Wed, 04 Sep 2019 09:19:44 GMT

Hi,

Can I achieve same in QlikSense as well?

Regards,

Bala