topic Re: Dynamically change bar chart background in QlikView

Dynamically change bar chart background

Wed, 29 Aug 2012 12:28:26 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 bar chart background

Gabriel — Wed, 29 Aug 2012 13:04:13 GMT

Hi,

Can I ask if my understanding of what you wanted is right. So you wanted the background of the graph to chnage to the color of the flag for the country? Not the color of the bar chart?

Re: Dynamically change bar chart background

Wed, 29 Aug 2012 13:06:23 GMT

Yes thats right the bars can stay the same colour, just the background image needs to change.

Thanks for your interest..

Re: Dynamically change bar chart background

whiteline — Wed, 29 Aug 2012 14:06:51 GMT

I think this link can help you.

http://www.wipfli.com/BlogPost_QT_BI_Blog_053111.aspx

Re: Dynamically change bar chart background

Wed, 29 Aug 2012 15:22:57 GMT

Thanks - but I got rather confused with the Bundle Load...

Still struggling to make this work!

Thanks

Re: Dynamically change bar chart background

whiteline — Wed, 29 Aug 2012 18:05:26 GMT

You can use it without boundle prefix.

info

LOAD

Country,

BackgroundFileName

FROM ... (complete yourself).

Now in Chart properties for 'Dynamic Image' expression simply use =info(Country)

If you add 'boundle' before 'info' QlikView include all your images inside .qvw file.