Product thumbnail images in product catalog in QlikView

[klaus_feldam]

We have a client who has a table in QlikView, where they are displaying their product items - like an online web/e-commerce product catalog, but without product images displayed as thumbnails.

They now want to add a column with product images displayed as thumbnails.

Has anyone done this with success in QlikView 9?

Any information/guides/documentation on how to best achieve this would be greatly appreciated.

[pover]

You can make the picture smaller with the "Fill" or "Fill with aspect" option in Images and then you can create a text object that shows the larger scale image once they select a product. The text object can even be hidden and only show up when one product is selected to give the impression that it is a pop-up.

Is that what you are looking for?

[#3]

hi,

See the attached application.. Hope it will help you.......

Keep a separate folder to save images.. Rename the images according to your ProductID

Items:
LOAD ItemID,
ItemDesc
FROM
Item.xlsx
(ooxml, embedded labels, table is ItemMaster);
ItemImages:
BUNDLE INFO LOAD
ItemID,
'Item\' & ItemID &'.GIF' AS img
FROM
Item.xlsx
(ooxml, embedded labels, table is ItemMaster);

regards,

Nilupa

[#4 · Accepted solution]

Hi Klaus,

I assume that you have the images stored in a folder and that all image names are unqiue.

You can achieve this by

1.) load all image paths as well as image file names into qlikview table using:

DIRECTORY

C:\Users\Administrator\Pictures; // Path of folder with images

for each image in filelist ('*.jpg'); // Here it loads jpg image REMEMBER TO USE CORRECT EXTENSION IF NOT JPG

let j= subfield(subfield(image,'\',-1),'.',1); // Get all File Names

Image_Archive: // Table name

LOAD * INLINE [

    Image_File_Names, Location 

    $(j), $(image)

    ];    

next image; // loop to load all images

2.) Note the "Image_File_Names" field name (Column Name) in the inline load statement. I will use this file name to link it to my product number (Product names) Thus the file names has to be the same as the product names.

Then add the "Location" as an expression in a straight of pivot table and set the representation as IMAGE

This should work just fine.

Kind Regards

Werner