topic Re: loading images in QlikView in QlikView

loading images in QlikView

Anonymous — Thu, 13 Aug 2015 14:43:21 GMT

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

Re: loading images in QlikView

petter — Thu, 13 Aug 2015 15:10:19 GMT

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.

Re: loading images in QlikView

Anonymous — Thu, 13 Aug 2015 15:22:01 GMT

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

Re: loading images in QlikView

petter — Thu, 13 Aug 2015 15:24:59 GMT

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

....

...

Re: loading images in QlikView

Anonymous — Thu, 13 Aug 2015 15:44:26 GMT

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.

Re: loading images in QlikView

petter — Thu, 13 Aug 2015 15:57:34 GMT

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()

Re: loading images in QlikView

Anonymous — Thu, 13 Aug 2015 16:38:33 GMT

Thanks a lot!

It works.