Change the picture based on selection

[brunolelli87]

Dears,

How can I insert a picture that will vary depending on the company selected?

I have a DataBase (CompanyLogo.xls) with the following content:

Company	Image Link
AZUL	https://www.oceans14.com.br/images/empresas/AZUL.gif
VALE	https://www.oceans14.com.br/images/empresas/VALE.gif
GOLL	https://www.oceans14.com.br/images/empresas/GOLL.gif

So, based on the customer's Company's selection I would like to show it's logo.

How can I do it?
Thanks

Bruno

[Durgadevikumar]

Hi Bruno,

I am not able to open your qvw file. However, i think due to small mistake it does not working properly.

refer the below link ,

https://www.analytics8.com/insights/bundle-loading-images-into-qlikview/

Also, find below script and output sample of which i did for your reference

Regards,

DurgadeviKumar

[Durgadevikumar]

Hi,

i am not able to open your qvw. file. however, i think due to small mistake it does not working properly.

kindly find the below information for your reference. Also make sure that the images are in the path specified.

my script:

Table1:
bundle LOAD Company,
[Image Link]
FROM
[..\import\lastmodify.xlsx]
(ooxml, embedded labels, table is Sheet8);

Sample Output:

Regards,

DurgadeviKumar

[brunolelli87]

Hello,

Thanks for your kindly assistance, but I figured out that:

1. When working with a single worksheet, with no connections, it's working perfectly;
2. When I try to connect it to my project with some key columns, it's not working.

Check my project:
I already have some fields, and one of those is called Company. Company is the key field, which connects some DataBase. If I try to create another excel file with Company and ImageLink the system does not work.

But If I create another excel file with Company2 and ImageLink the system work, but obviously, does dot show anything when the user select a Company, just show something when he select a company on Company 2 Field.

Is there any way to solve it?