Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to load a table which consists of two fields: the first field should contain the images in png-format, the second - the names of the images.
As a source I have 10 files in png-format:
image1.png
image2.png
image3.png
image4.png
image5.png
image6.png
image7.png
image8.png
image9.png
image10.png
How can I load such a table?
Thank you in advance,
Larisa
Yes it is possible to load the images into the QVW-file. But if there are many big image-files remember that this is loaded all into memory on your server.
This technique is called BUNDLE INFO LOAD. You simply add the keyword BUNDLE in front of the LOAD statement.
However the table should now only contain two columns. One that gives the unique ID / reference so you can pick the right image later in your application and the second one the full path to an external image file.
The way to use it in the UI is quite a bit different as you have to make an expression that looks like:
='qmem://FileNo/6'
Where 6 is the ID
or if you use a table chart:
='qmem://FileNo/' & RowNo()
You can create a table in your load script like this:
SET v.ImagePath = 'C:\Users\XYZ\Pictures\';
Images:
LOAD
RecNo() AS FileNo,
FileName,
'$(v.ImagePath)' & FileName AS FullFileName
INLINE [
FileName
2015-07-06 #1 How to Sum within a Sub Loop.PNG
2015-07-07 x-axis all values #1.PNG
2015-07-07 x-axis all values #2.PNG
2015-07-08 x-axis all values #3.PNG
2015-07-08 x-axis all values #4.PNG
2015-07-11 #1.PNG
2015-07-11 #2.PNG
2015-07-14 #1.PNG
2015-07-26 #1.PNG
2015-07-29 #1.PNG
];
The you can add the field FullFileName as an expression in a table box, straight table, pivot table and make sure that you select Image as Presentation for this expression. You could also display images in many other sheet objects like in a text box too.
Hi Petter,
I don't quite understand what you mean by that list?
2015-07-06 #1 How to Sum within a Sub Loop.PNG
2015-07-07 x-axis all values #1.PNG
2015-07-07 x-axis all values #2.PNG
2015-07-08 x-axis all values #3.PNG
2015-07-08 x-axis all values #4.PNG
2015-07-11 #1.PNG
2015-07-11 #2.PNG
2015-07-14 #1.PNG
2015-07-26 #1.PNG
2015-07-29 #1.PNG
It is just a list of filenames. You have to provide your own image filenames like for example:
Image424332.png
Image1000.png
MyFather.PNG
MyDog.PNG
....
...
It's clear.
I've got another question:
When I publish a dashboard on the server I usually publish qvw-file and no other files.
The path from my local computer (say, 'C:\Users\XYZ\Pictures\') will make no sense on the server.
Is it somenow possible to keep all the images within qvw-file?
I'd like to load the images to the qvw-file once and then while operating on the forefront take them from QlikView and not from disc C.
Yes it is possible to load the images into the QVW-file. But if there are many big image-files remember that this is loaded all into memory on your server.
This technique is called BUNDLE INFO LOAD. You simply add the keyword BUNDLE in front of the LOAD statement.
However the table should now only contain two columns. One that gives the unique ID / reference so you can pick the right image later in your application and the second one the full path to an external image file.
The way to use it in the UI is quite a bit different as you have to make an expression that looks like:
='qmem://FileNo/6'
Where 6 is the ID
or if you use a table chart:
='qmem://FileNo/' & RowNo()
Thanks a lot!
It works.