Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
BI Consultant
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,
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
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.
BI Consultant
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:
Best regards
Simon
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
Thank you all for your suggestions, all sorted now! Bri.
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'
Forget it, the example was perfect, Imade a simple stupid mistake.
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