topic Re: Complex IF Statement in QlikView

Complex IF Statement

amber2000 — Tue, 28 Oct 2014 12:28:27 GMT

Hello everybody,

I'm strugling with an expression that contains a nested if statement on the Text Color propertie.

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0,

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and [Reele_loc_Hgt] >= 185, green(),red()))

The above statement is working as it should but the first rule should contain one more logic comparison:

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 <= 99.99,

When I implement this my rules are not applied.

I'll attach an example to see what I'm doing, I also use the visual cues.

Can anybody help me with this please ???

Kind regards,

Ambertje

Re: Complex IF Statement

Tue, 28 Oct 2014 12:37:06 GMT

Hi,

Is this what you are looking for?

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100<=99.9,green(),

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >=100.0 and [Reele_loc_Hgt] >= 185, red()))

Re: Complex IF Statement

amber2000 — Tue, 28 Oct 2014 12:51:45 GMT

Sorry Reddy but this is not correct,

Both If statements should result as green and all that doesn't match should be in red.

Re: Complex IF Statement

Tue, 28 Oct 2014 12:54:26 GMT

Ok for that use the below.

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100<=99.9,green(),

If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 100.0 and [Reele_loc_Hgt] >= 185, green(),red()))

Re: Complex IF Statement

amber2000 — Tue, 28 Oct 2014 13:22:40 GMT

Thank you so much, now I see how to build a nested If, totaly different then how I used nested If's in excel for example.

Kind regards,

Ambertje