this is a rather trivial question: I am looking for the formula to do a certain thing, but the name I have in mind is not the same in QlikView and I just don't find it:
- To set the status_lights on the diagrams in my apps (red/ green), I calculate something to compare with a target_value, sometimes rather complex (usually the avg of the past week vs. a fixed value, sometimes a fixed value vs. a calculated target)
=> Now I want to include a third status, "yellow", in the status_lights. Then I will have the following logic:
- Value on target (above or below target_value, depending...) -> green
- Value within 5% of target -> yellow
- Value missed target by more than 5% -> red
The thing is: Currently, I calculate the middle status, "yellow", by using an IF-condition with two arguments:
>>> value>target AND value<=(target*1.05) <<<
=> I'm sure there is some way to do that in a more elegant way, but I just can't find the right formula.
Can someone tell me what that would be? (Sth. like "BETWEEN")
