Nested if

[Anonymous]

Hi Qlik Experts I have a problem.

I'm trying to optimize an IF statement that I have in a Load. This is my IF expression:

If(Adt>0 and Adt <200,'E',

  If(Adt>=200 and Adt <500,'D',

  If(Adt>=500 and Adt <1200,'C',

  If(Adt>=1200 and Adt <2700,'B',

  If(Adt>=2700 and Adt <100000,'A'))))) as Segment

Any suggestion?

Thanks!!!

[Peter_Cammaert]

Any idea whether this one perfoms better/is faster than the typical nested IF from the Original Post?

[MarcoWedel]

No, I didn't test the performance, so using a string operation it might even be slower ...

[Anonymous]

Thanks a lot Marco!!

I tried all the different options and this was the option with the best performance.

[MarcoWedel]

Glad it helped

thanks for your feedback.

regards

Marco