Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
klaus_feldam
Creator II
Creator II

Product thumbnail images in product catalog in QlikView

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.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

3 Replies
pover
Luminary Alumni
Luminary Alumni

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?

Not applicable

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

Not applicable

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