topic Re: Bar graph with conditional colors?? in QlikView

Bar graph with conditional colors??

qlikuser222 — Wed, 23 Mar 2016 15:30:17 GMT

Hi,

i have a requirement with bar graph.

Please find attached which explains my requirement.

thanks

Re: Bar graph with conditional colors??

nagireddy_qv — Wed, 23 Mar 2016 15:47:39 GMT

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

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

Re: Bar graph with conditional colors??

qlikuser222 — Wed, 23 Mar 2016 16:15:32 GMT

Hi,

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

Thanks

Re: Bar graph with conditional colors??

maxgro — Wed, 23 Mar 2016 20:15:46 GMT

PFA

Re: Bar graph with conditional colors??

MarcoWedel — Wed, 23 Mar 2016 23:02:39 GMT

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