Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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
Sorry - please bear with me!!
Do I create a table externally (.xls, .csv etc) or within Qlikview (New Sheet Object etc..)
Thanks
In script - either an inline table or load from Excel,csv,etc
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
I've answered you in your previous thread.
http://community.qlik.com/message/252968#252968
Have you tried the sollution ?
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..
Heres the chart properties
Please show me the error of my ways!!
Thanks
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 ?
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);
;
No, just select one Club value from list box.
Seems everything's right. What's not working ?