topic setting threshold in QlikView

setting threshold

Fri, 23 Oct 2009 13:00:48 GMT

I have a simple bar chart for which i'm trying to set a threshold value. As in if the value of a certain field crosses a threshold value, either the entire bar must change color or the part of the graph that has exceeded the threshold value must change color. Any ideas on how this is possible?

setting threshold

Fri, 23 Oct 2009 14:40:23 GMT

Hi,

see the attached example.

Good luck!

Rainer

setting threshold

Fri, 23 Oct 2009 19:48:38 GMT

ive added an expression in the expression>background selection like "if(quantity>300, LightBlue(),LightGreen())"

This changes the color of the entire bar. Is it possible to only change the color of the part of the bar that exceeds the threshold?

setting threshold

Fri, 23 Oct 2009 20:00:38 GMT

Hi,

as you will see in the modified example it works in the way you want.

Rainer