topic Re: Dynamically change a bar chart background in QlikView

Dynamically change a bar chart background

Wed, 29 Aug 2012 12:32:19 GMT

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

Re: Dynamically change a bar chart background

m_woolf — Wed, 29 Aug 2012 13:14:19 GMT

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

Re: Dynamically change a bar chart background

Wed, 29 Aug 2012 13:20:05 GMT

Sorry - please bear with me!!

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

Thanks

Re: Dynamically change a bar chart background

m_woolf — Wed, 29 Aug 2012 13:21:43 GMT

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

Re: Dynamically change a bar chart background

Wed, 29 Aug 2012 14:02:18 GMT

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

Re: Dynamically change a bar chart background

whiteline — Mon, 03 Sep 2012 11:45:31 GMT

I've answered you in your previous thread.

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

Have you tried the sollution ?

Re: Dynamically change a bar chart background

Mon, 03 Sep 2012 14:17:14 GMT

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

Re: Dynamically change a bar chart background

whiteline — Mon, 03 Sep 2012 14:33:22 GMT

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 ?

Re: Dynamically change a bar chart background

Mon, 03 Sep 2012 15:17:10 GMT

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);

;

Re: Dynamically change a bar chart background

whiteline — Mon, 03 Sep 2012 15:28:01 GMT

No, just select one Club value from list box.

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

Re: Dynamically change a bar chart background

Mon, 03 Sep 2012 15:30:54 GMT

I get no image at all...:(

Re: Dynamically change a bar chart background

whiteline — Mon, 03 Sep 2012 15:32:50 GMT

Could you try to enter one of the values directly, for example

='C:\Images\Arsenal.png'

Re: Dynamically change a bar chart background

Mon, 03 Sep 2012 15:35:21 GMT

Yes that displays the image correctly..

Re: Dynamically change a bar chart background

whiteline — Mon, 03 Sep 2012 15:44:15 GMT

ok replace it with =info(Club)

then replace the asterisk in your load with:

Club,

Logo

order is important.

Re: Dynamically change a bar chart background

Tue, 04 Sep 2012 08:12:44 GMT

No go - sorry!!

This was how it was cripted before (could it be the location of the files (folder structure?))

Thanks

Re: Dynamically change a bar chart background

whiteline — Tue, 04 Sep 2012 08:20:05 GMT

Strange, mine works fine.

You can try to include all your images into .qvw file adding the word boundle before info LOAD.

But I think the problem is somewhere else.

Could you attach your file (you can exclude all except that load and that chart) ?

Re: Dynamically change a bar chart background

Tue, 04 Sep 2012 08:33:41 GMT

Not sure how is the best way to send you the chart??

Re: Dynamically change a bar chart background

whiteline — Tue, 04 Sep 2012 08:35:51 GMT

As qvw file.

Re: Dynamically change a bar chart background

Tue, 04 Sep 2012 08:46:08 GMT

Premiership4.qvw

Re: Dynamically change a bar chart background

whiteline — Tue, 04 Sep 2012 08:55:24 GMT

Now I understand.

Your field Club is not connected with your data.

Add a list box with Club and you'll see.