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,

Bundle load which is used to insert the image into the qlikview application.

load the Companylogo.xls which consist of two field( company and image link)

the script for bundle load,

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

save and load the script and in the front end change the representation is "image" under the general tab in any type of chart or text object. 

And, provide the expression is,

=info(Company)

Based on selection in the company filter logo has been changed.

Hope you are understanding😊

Regards,

DurgadeviKumar

[brunolelli87]

Hello,

Thanks for your help, but I'm getting the following error:
"Error: Error in Expression: Info Function takes a valid field name as paramenter "

How can I solve it?
Thanks

[Durgadevikumar]

Hi, 

= info(give the field name that has the company details) it's working perfectly for me.

If, further you will find the issue means pls share the screenshot of ur code

Thank you, 

DurgadeviKumar

[brunolelli87]

Please, check the following picture

[Durgadevikumar]

Hi,

Give

= info(Sticker)  and choose the image as representation under general tab of text object

Regards,

Durgadevikumar

[brunolelli87]

Hello, 

I'm still getting the same error, please check the picture below:

[Durgadevikumar]

Hi,

Can you please share the .qvw file

Regards,

Durgadevikumar

[brunolelli87]

Yes, of course, I can!
Thanks for your help!!!

I'm using a personal Edition of QlikView, so I don't know if I'll able to open your file back (in case of)...

But I really appreciate your assistance!

[Durgadevikumar]

Hi Bruno,

I am not able to open your qvw File. however, I think due to small mistake it does now working  properly,

Refer the below link,

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

and find my code  and output sample below  for your reference,

Regards,

DurgadeviKumar