Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies