Hi I need to build a nested If statement in qlikview, the trouble I have is that each stagemust have a else statement.
can this be done?
yes but you need to be much more specific.
something like this
IF(X = 1 AND CALCULATION1 > CALCULATION2, GREEN, RED), --- First If Statement
IF(Y = 3 AND CALCULATION1 < CALCULATION2, RED, GREEN), --- Second If Statement
IF(CALCULATION1 > CALCULATION2, RED, GREEN) --- Last If Statement
This can be combined into one :
IF(not (X = 1 AND CALCULATION1 > CALCULATION2) or (Y = 3 AND CALCULATION1 < CALCULATION2) or (CALCULATION1 > CALCULATION2), RED, GREEN)
Cool. Thanks it work
Please move this discussion to the correct group.
Retrieving data ...