Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamically change a bar chart background

Hi

I am a newbie!

I am using Version 11.00.11282.0

I am trying to dynamically change the background image (.jpg) of a bar chart - depending on the selection. ie Country Flags.

when I select 'Dynamic Image' the expresssion entry sheet pops up - but I have no idea what or how I should create the script within this box.

I cant find this detailed anywhere.

Any ideas please?

Thanks

1 Solution

Accepted Solutions
whiteline
Master II
Master II

As I've said,

You have to connect the field Club and the field [Home Team].

For example, just rename Club into [Home Team] (if there are the same values):

Info Load

Club as [Home Team],

Logo

FROM

Clublogo.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

View solution in original post

22 Replies
m_woolf
Master II
Master II

Create a table of Countries and Flag Graphics:

Country, FlagGraphic

USA, c:\Flag\usa.png

Canada, c:\flag\canada.png

eitc, etc

in the expression box, put: =FlagGraphic

Not applicable
Author

Sorry - please bear with me!!

Do I create a table externally (.xls, .csv etc) or within Qlikview (New Sheet Object etc..)

Thanks

m_woolf
Master II
Master II

In script - either an inline table or load from Excel,csv,etc

Not applicable
Author

Hi

Thanks - that works when I select the appropriate club from the dropdown of the newly created multibox.

But I want to do this dynamically when I select teh club from an  existing listbox..

I hope thats clear..

Thanks again for your help and patience

whiteline
Master II
Master II

I've answered you in your previous thread.

http://community.qlik.com/message/252968#252968

Have you tried the sollution ?

Not applicable
Author

I think I must be missing something..

Heres the script..

//Load Logos

Logos:

LOAD Club,

     Logo

FROM

Clublogo.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Heres the clublogo.csv data..

clublogo.png

Heres the chart properties

clublogo2.png

Please show me the error of my ways!!

Thanks

whiteline
Master II
Master II

First, you do regular load instead of info LOAD.

Second, you should use =info(Club) as a dynamic image.

Why do you completely avoid the word 'info' ?

upd:

You could do it without info as you're trying.

Where did you type your expression =Logo ?

Not applicable
Author

Do I need an info select as well as an info load statment in the script?

//Load Logos

Logos:

Info Load * FROM

Clublogo.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

;

clublogo3.png

whiteline
Master II
Master II

No, just select one Club value from list box.

Seems everything's right. What's not working ?