Qlik expression

[babud41]

Hi All,

Hope you all are extremely fine after this pandemic.

=IF(AND(V2="Activated",U2="No appointment"),"Activated with No Appointment",

IF(AND(V2="Activated",U2="Appointment given",((K2-H2)*24)>=0),"Activated with in appointment",

IF(AND(V2="Activated",U2="Appointment given",((K2-H2)*24)<0,((K2-H2)*24)>-0.3),"Activated within 30 mins of Post appointment",

IF(AND(V2="Activated",U2="Appointment given"",((K2-H2)*24)<=-30),"Activated by crossing ETR"

The above is an Excel formula.

Here in My Qlik,

V2 = Status , U2 = Appointment_day is not null , K2-H2*24 =  Appointment GART

I will a snap for the qlik straight table.

How to get the result as in excel as  "Activated with No Appointment" , etc..

Kindly help

Regards,

Dinesh
India

[rubenmarin]

Hi, the syntaxis could be:

If(Status='Activated' and IsNull(Appointment_day)
  ,'Activated with No Appointment'
  ,If(Status='Activated' and not IsNull(Appointment_day) and [Appointment GART]>=0
    ,'Activated with in appointment'
    ,If(Status='Activated' and not IsNull(Appointment_day) and [Appointment GART]>-0.3
      ,'Activated within 30 mins od Post appointment'
      ,If(Status='Activated' and not IsNull(Appointment_day) and [Appointment GART]<=-30
        ,'Activated by crossing ETR'
))))