Searching for the right formula

datanibbler — Mon, 30 Sep 2013 12:22:56 GMT

Hi,

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")

Thanks a lot!

Best regards,

DataNibbler

topic Searching for the right formula in QlikView

Searching for the right formula