Area for people to learn more about current Qlik related job postings.
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?
Go to Solution.
This can be combined into one :
IF(not (X = 1 AND CALCULATION1 > CALCULATION2) or (Y = 3 AND CALCULATION1 < CALCULATION2) or (CALCULATION1 > CALCULATION2), RED, GREEN)
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
Cool. Thanks it work
Please move this discussion to the correct group.