Bar graph with conditional colors??

[qlikuser222]

Hi,

i have a requirement with bar graph.

Please find attached which explains my requirement.

thanks

[nagireddy_qv]

HI

could you apply the condition in the Expression tab--> click on + symbal--> Add conditions in the backgorund option.

or

Go to colors tab--> add your conditions..

[qlikuser222]

Hi,

Thanks for reply, but i cant put ficked background color as the values changes dynamically.

Thanks

[maxgro]

PFA

[MarcoWedel]

besides coloring your bars you could crosstable load your data to get single Task and Day fields as well as TaskNumber and DayNumber fields you could use as dimensions.

Instead of 4 similar expressions your chart would only need one (and also having only one colour expression)

hope this helps

regards

Marco