Color coding for Bar chart

[MPS]

Dear All,

I am trying to add different color to the bar chart which is by Week ending. Need 

Dimension -- =WeekEnd([Estimated Pre-Approval Date])

Help required -- Need the chart to show in different color for all previous weeks weeks. Current week is 03/20/2021, so all week before to show a different color. I tried with one expression under 'Colors & legend', but didn't workout. could you please help.

tried expression, but failed --- =if(WeekEnd([Estimated Pre-Approval Date])<'Today', 'pink', 'blue')

[agigliotti]

Hi @MPS ,

Maybe this:

=if( WeekEnd([Estimated Pre-Approval Date])<Today(), rgb(255,192,203), blue() )

I hope it can helps.

Best Regards

[MPS]

Thank you for the quick response, but the bar chart all went blue. Do i have to add any single quotes for any of these fields. 

[agigliotti]

you have to check the date format, try:

=if( num(WeekEnd([Estimated Pre-Approval Date]))<num(Today()), rgb(255,192,203), blue() )

[MPS]

Sorry, this didn't work either 😟. Do you need the expression for you to check and validate, not sure if that could be the reason. 

below are my Qlik color codes, 

Blue - 080047
Pink - e30d75

[NitinK7 · Accepted solution]

Select color->custom->By dimension

an write exp -if(WeekEnd([Created Date])<Today(),Red(),Blue())

[agigliotti]

yes, could be useful to look at your "Colors By expression"...

[MPS]

Thanks a ton, this actually worked

[MPS]

Thank you so much for your kind help. You have always been prompt & first person to respond. Much appreciated 🤗