topic Re: Conditional Color Change on Bar Chart in QlikView

Conditional Color Change on Bar Chart

techvarun — Wed, 26 Nov 2014 11:45:11 GMT

Hi All,

I have a bar chart as Market as dimentions and sum(sales) as expression and I have one more list box called Market Name.

My requirement is if i check 5 on list box only 5 should highlighted with some different color or bold,

I have managed to change the color of all markets but not the particular one.

if(GetFieldSelections([Market Name])= '5', Green())

in this case only 5 should display as green and not all the markets

Thanks

Varun

sujeetsingh — Wed, 26 Nov 2014 11:51:03 GMT

Right this on the Expression background colour attribute

techvarun — Wed, 26 Nov 2014 11:52:38 GMT

Hi Sujeet

Thanks for ur reply.

my requirement is if select 5 on list box only five get highlighted on bar chart Y axis

Thanks

Varun

tresB — Wed, 26 Nov 2014 12:00:03 GMT

Use expression like:

=Sum({<[Market Name]>} Sales)

And then your expression if(GetFieldSelections([Market Name])= '5', Green()) should work the way you want.

Edit: Corrected field name

techvarun — Wed, 26 Nov 2014 12:07:44 GMT

Hello Tresco,

Thanks for ur reply

PFA data model.

Bar chart and list box don't have any link.

Thanks

Varun

tresB — Wed, 26 Nov 2014 12:11:42 GMT

In that case, it should work without that set expression inclusion. Can you share a sample qvw that demonstrates the issue?

techvarun — Wed, 26 Nov 2014 12:17:50 GMT

Please find the attached qvw

tresB — Wed, 26 Nov 2014 12:24:33 GMT

I tried with background color.

Exp: If([Market Name]=1 and Market=1, Red(), Green())

You have to modify accordingly.

PFA

Update: to make it dynamic use something like: If([Market Name]= Market, Red(), Green())