Nested IF in Load Scrirpt

[mja_jami]

Dear Qlik experts,

How can I write the load script so that it will populace a field 'Status' (i.e.;Flat Cancelled/ Reg Cancelled/ Active) checking two fields (cancel_date, premium) :

If cancel_date is not Blank/ Null and premium < 0; Then, Status = “Flat Cancelled” ,

If cancel_date is not Blank/ Null and premium >= 0; Then, Status = “Reg Cancelled” ,

If cancel_date is Blank/ Null; Then, Status = “Active”

Thank you very much for help.

Best regards,

Jami

[bhargav_bhat]

Hi Mja_jami,

Below is the required expression

if(isnull(cancel_date) or cancel_date='' ,'Active',if(premium<0,'Flat Cancelled','Reg Cancelled')) as Status

Regards,

Bhargav

[mja_jami · Accepted solution]

Thank you Bhargav,

I used this below and worked.

if(isnull(cancel_date) or cancel_date='' ,'Active',if(premium<0,'Flat Cancelled','Reg Cancelled')) as Status

Thanks very much.

[bhargav_bhat]

Hi Mja_jami,
Can you please mark it as correct if you got the solution
Regards,
Bhargav

[marcos_rv_666]

Holis!!!

Try this

IF( isnull (cancel_date ) OR cancel_date = ' ' , 'Active', IF (  premium < 0 , 'Flat Cancelled', 'Reg Cancelled' )) AS Status 

Saludos!!!

[Channa]

IF( Len(Canceldate)>0 and Premium>0, ststus='Flat cancel',IF(Len(Canceldate)>0 and Premium>0, ststus='REg cancel',RedCancel'))

try like this