Nested If on Expression to set Text Color

Thu, 11 Apr 2013 14:16:18 GMT

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:

IF(Sum({$<CAP_OM=('Capital'),Craftline_Desc={'Dispatch'}>}Current_Actuals/

((Sum({$<CAP_OM=('Capital'),Craftline_Desc={'Dispatch'>}Current_Actuals+Sum($<CAP_OM=('O&M'),Craftline_Desc={'Dispatch'}>}Current_Actuals))>0.20,LightGreen())

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.

Thanks,

Mark

topic Nested If on Expression to set Text Color in QlikView

Nested If on Expression to set Text Color