How to link image file with data model & visualize in Table chart in Qlik Sense

[Arindam_Ghoshal_13]

Hello Experts,

I am trying to link image data with existing data model .
My images are stored in local folder in my desktop.

I have MonthYear field in my data model where I want to show 2 images ( beforeIMG & afterIMG ) for each month in a straight table.

Below is the code I tried to link with with my data model field MonthYear.

**************       code after load other table & master cal       *******************

Image_Before:
// Bundle
// Info
Load * Inline [

MonthYear, Image_Before

Jan-2022, //PC_NAME/filepath1/Jan-2022.jpeg
Feb-2022, //PC_NAME/filepath1/Feb-2022.jpeg
Mar-2022, //PC_NAME/filepath1/Mar-2022.jpeg
Apr-2022, //PC_NAME/filepath1/Apr-2022.jpeg
];

Image_After:
// Bundle
// Info
Load * Inline [

MonthYear, Image_After

Jan-2022, //PC_NAME/filepath2/Jan-2022.jpeg
Feb-2022, //PC_NAME/filepath2/Feb-2022.jpeg
Mar-2022, //PC_NAME/filepath2/Mar-2022.jpeg
Apr-2022, //PC_NAME/filepath2/Apr-2022.jpeg
];

****************************************************************
I want to visualize this image in table chart in below format which is achieved in QlikView but not working in Qlik Sense.

I want to achieve this in table chart in Qlik Sense .

Thanks in advance. Suggestions are welcome.

#Image Visualization, #Qlik Sense, #LoadImageData

[Andrei_Cusnir · Accepted solution]

Hello,

If my understanding is correct, you want to load images from local directory into your Qlik Sense's Straight Table as you do in QlikView. According to the post "Help with Image Load in qliksense" [1], for Qlik Sense you will have to use "Content library" in QMC.

Here are the steps that I have followed to achieve this use case scenario:

1. I have 6 images of dogs:

2. In "QMC > Content libraries" I have created a new content library "Dogs" and under "Contents" I have uploaded the 6 images:

3. In Data load editor I have the following script:

Test:
Load * inline [
Value, Link
A, https://SERVER.domain.local/content/Dogs/dog1.jpg
B, https://SERVER.domain.local/content/Dogs/dog2.jpg
C, https://SERVER.domain.local/content/Dogs/dog3.jpg
D, https://SERVER.domain.local/content/Dogs/dog4.jpg
E, https://SERVER.domain.local/content/Dogs/dog5.jpg
F, https://SERVER.domain.local/content/Dogs/dog6.jpg
];

As you can see I have used the prefix "https://SERVER.domain.local" of my server and the "URL path" provided by the Content library.

4. In my app's sheet I have created a Table with Value and Link fields as dimensions.

5. For the Link field I have setup the following configuration:

• Representation: Image
• Image setting: Add URL
• Image URL: =Link

6. The outcome is:

As you can see the images are loaded properly in the Table chart in Qlik Sense.

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 

---

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/Help-with-Image-Load-in-qliksense/td-p/1122674