Using Qlikview with imported data to change bar graph
I am trying to use Qlikview to display data imported from SQL as a bar graph. I want to make it so that if the bar graph value is below 2, the bar will turn red in color. Also, if the bar value is above 15, it will be black in color. Anything in between I would like to be green.
In C# code, something along the lines of this:
If (QuantityOnHand < 2)
Turn color red
Else If (QuantityOnHand > 15)
Turn color black
Turn color green
Can somebody please direct me on the best way to accomplish this in Qlikview?
Re: Using Qlikview with imported data to change bar graph
This helped a lot, thank you. I am still having some problems with this, however. If I have a bar that goes up to 22 and I would like the first 2 sections to be red, sections 2-15 to be green, and 15-22 to be black, what would be the best way to accomplish this?