topic Re: Change the picture based on selection in QlikView

Change the picture based on selection

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Change the picture based on selection

Durgadevikumar — Mon, 11 May 2020 09:32:53 GMT

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

Re: Change the picture based on selection

brunolelli87 — Mon, 11 May 2020 15:10:43 GMT

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

Re: Change the picture based on selection

Durgadevikumar — Mon, 11 May 2020 15:18:02 GMT

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

Re: Change the picture based on selection

brunolelli87 — Mon, 11 May 2020 15:40:47 GMT

Please, check the following picture

Re: Change the picture based on selection

Durgadevikumar — Mon, 11 May 2020 15:45:50 GMT

Hi,

Give

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

Regards,

Durgadevikumar

Re: Change the picture based on selection

brunolelli87 — Mon, 11 May 2020 15:50:15 GMT

Hello,

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

Re: Change the picture based on selection

Durgadevikumar — Mon, 11 May 2020 16:08:48 GMT

Hi,

Can you please share the .qvw file

Regards,

Durgadevikumar

Re: Change the picture based on selection

brunolelli87 — Mon, 11 May 2020 16:11:20 GMT

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!

Re: Change the picture based on selection

Durgadevikumar — Tue, 12 May 2020 06:08:08 GMT

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

Re: Change the picture based on selection

Durgadevikumar — Tue, 12 May 2020 07:27:55 GMT

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

Re: Change the picture based on selection

Durgadevikumar — Tue, 12 May 2020 07:45:02 GMT

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

Re: Change the picture based on selection

brunolelli87 — Tue, 12 May 2020 14:02:17 GMT

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?