0 Replies Latest reply: Apr 11, 2013 10:16 AM by Mark Ketchaver RSS

    Nested If on Expression to set Text Color

      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