Hi everyone - I'm a brand new QlikView user and am struggling to get a nested IF statement to work. I'm trying to set the expression text color based on an IF statement and will need a few nested together to accomplish this.
For example, the following works fine for one criteria:
However, when I try to nest another IF after LightGreen (using the same IFstatement, just changing Craftline_Desc = Engineering) the statement is invalid.
So Dispatch may be measured against > 0.20, Engineering 0.50, etc etc.
Any tips? There is probably a better way to accomplish this so I'm open to suggestions.