Change background based in dimension formula result value

[Anonymous]

Hi Everyone,

i'm totally new to the QLik software at my company im trying to do the following:

Current Phase = Text based from a data package at my company.

Record Age = number that represents the days open for a document.

=if (([MDD_NC_MAIN.NC_Current_Phase] = 'Initiate') AND ([MDD_NC_MAIN.NC_Record_Age__days_] <= 2),'On Time'

,if (([MDD_NC_MAIN.NC_Current_Phase] = 'Initiate') AND ([MDD_NC_MAIN.NC_Record_Age__days_] > 2),'Overdue','Cond3'))

so the question is how can i change the field background if i have the above formula?

if it is "On Time" change to "Green", "Overdue" change to "Red" i have seen examples in where one of the results from the nested if is in fact the color like "Red()" however since my formula already has the value based in the conditional how can i use the background expression editor to check my dimension field expression formula and determine the color based in the value??

thank you

Eduardo V.

[dwforest · Accepted solution]

You would have to duplicate the if statement in the background color or set your current expression as a Variable, but you'd still need to write an expression for the background color, if(varOnTime='On Time',green, red).

[Anonymous]

Hi David,

yes you were right i copied the formula in the background color expression and replace the True/False values with the corresponding colors and it worked, thanks for the answer.

regards,

Eduardo V.