Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Qlikview Import All Images in Folder

HI There,

Is there anyway to import a batch of pictures into qlikview?

I would like to import the images into 1 column and import the file names into another column?

Kind Regards

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Qlikview Import All Images in Folder

Hi to all,

I have found the solution in the following blog:

http://community.qlik.com/message/161553

To load all the images into the qvw would be insane. So the best method as described from the blog above is to reference the images and allow qlikview to point to the image files using the method below

for each image in filelist ('*.png'); // Here it loads png image
let j= subfield(subfield(image,'\',-1),'.',1);

Smiley: // Table name
LOAD * INLINE [
    Smile, Location // Fields under the table
    $(j), $(image) // Image name and the location
    ];    
next image; // loop to load all images

3 Replies
nagaiank
Valued Contributor III

Re: Qlikview Import All Images in Folder

Did you try BUNDLE prefix in the LOAD statement? The details are in the Qlikview Reference Manual.

Not applicable

Re: Qlikview Import All Images in Folder

hi krishamoorthy,

thank you for your reply. If I understand correctly, the bundle load picture will import binary BLOB data and not all the pictures in 1 folder that i have.

I would for qlikview to load all the images as well as their corresponding file names

Please let me know if you know of any way that i can achieve this

Kind Regards

Not applicable

Re: Qlikview Import All Images in Folder

Hi to all,

I have found the solution in the following blog:

http://community.qlik.com/message/161553

To load all the images into the qvw would be insane. So the best method as described from the blog above is to reference the images and allow qlikview to point to the image files using the method below

for each image in filelist ('*.png'); // Here it loads png image
let j= subfield(subfield(image,'\',-1),'.',1);

Smiley: // Table name
LOAD * INLINE [
    Smile, Location // Fields under the table
    $(j), $(image) // Image name and the location
    ];    
next image; // loop to load all images

Community Browser