Formula help

[datanibbler]

Hi,

my question first:

=> Is there an easier (shorter) way of writing the condition

>>> A > 20 AND A <= 30 <<<

=> This might not seem like much, but I have to define a status light that has three potential outcomes (green/yellow/red), based on two separate limits (each of which can actually take on any of those three stati, which have to then be combined into one), which makes for an awful lot of brackets...

Thanks a lot!

Best regards,

DataNibbler

[sujeetsingh]

use nested if statement with AND operator

[hic]

A nested If() is the answer. But I don't think you need the AND. Instead you can do it like

If( A <= 20, 'Red',

If( A <= 30, 'Yellow',

     'Green')) as NewField

HIC

[datanibbler]

Hi Henric,

that was what I intended to learn:

=> I know that in another software I worked with, the first (topmost) condition was tested first and then sort of taken for granted, so you wouldn't have to repeat it (in reverse form) as part of the second condition.

If that works in QlikView, that will save me some typework in this instance - well, I've already done it, so that would not make a difference, but it will make the whole thing easier to understand for others, and that's another thing I am aiming at.

Best regards,

DataNibbler

P.S.: Yep, it seems to work - at least the status_symbol is still there and for now it is even showing the same outcome that I had before. I'll just have to monitor it from time to time.