Bar Chart Colors

[elie_issa]

Dear All,

I need to get the below colors having one dimension month_year and one expression showing the completeness rate.

The green color should be given for the last month year we are showing in our chart (Apr 2017 in the below pic) and then the other months should show the grey color lighter for the previous month and darker for the last month (Nov 2016 in the below pic)

[felipedl]

Hi Elie,

You could add another dimension for each month you have, so that it's possible to do the gradient you want.

Attached is an example of what I did.

Regards,

Felipe

[rwunderlich · Accepted solution]

Nice solution Felip. I modified your color expression a bit to eliminate the need for an Index field and to handle a variable number of bars.

=if(Month=Max(Total Month)

,RGB(181,230,29)

,ARGB(255*(1- (Rowno() / Bottom(RowNo()))),0,0,0)

)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[elie_issa]

thanks a lot it works