topic Bar Chart Colors in QlikView

Bar Chart Colors

elie_issa — Tue, 23 May 2017 16:11:37 GMT

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)

Re: Bar Chart Colors

felipedl — Tue, 23 May 2017 18:18:58 GMT

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

Re: Bar Chart Colors

rwunderlich — Tue, 23 May 2017 21:40:58 GMT

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

Re: Bar Chart Colors

elie_issa — Wed, 24 May 2017 06:43:49 GMT

thanks a lot it works