Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

Nested If Statement

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?

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: Nested 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)


5 Replies
giakoum
Honored Contributor II

Re: Nested If Statement

yes but you need to be much more specific.

Not applicable

Re: Nested If Statement

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

giakoum
Honored Contributor II

Re: Nested 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)


Not applicable

Re: Nested If Statement

Cool. Thanks it work

giakoum
Honored Contributor II

Re: Nested If Statement

Please move this discussion to the correct group.

Thank you.

Community Browser