Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tim_leijen
Contributor III
Contributor III

Visuals in Qlikview charts

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?

1 Solution

Accepted Solutions
prma7799
Master III
Master III

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

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

View solution in original post

4 Replies
Anil_Babu_Samineni

May be try this expression in your Background color of expression

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Master III
Master III

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

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

neha_shirsath
Specialist
Specialist

Hi,

Please find the attached file.

Hope it will help you.

Thanks,

Neha

tim_leijen
Contributor III
Contributor III
Author

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