Visuals in Qlikview charts

[tim_leijen]

Goodmorning,

Yesterday I created the chart below, which basically shows the difference between budget and actuals for a couple of our customers.

Now I want all the bars below 0 to color red, and all the bars above to color green.

On the forum I read about visual cues, however it seems we don't have this option, maybe we are working with an older QV version

Is this possible without visual cues? If so, how?

[Anil_Babu_Samineni]

May be try this expression in your Background color of expression

If(Sum(Sales) <0, Green(), Red())

[prma7799 · Accepted solution]

Go to expression >> Background color >> write your condition

if( Sum(sale) > 0 , Green (),  Red())

[neha_shirsath]

Hi,

Please find the attached file.

Hope it will help you.

Thanks,

Neha

[tim_leijen]

Thanks guys! Didn't know this option yet, but it worked!