Qlik expression

babud41 — Fri, 17 Dec 2021 05:13:15 GMT

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

Re: Qlik expression

rubenmarin — Sun, 19 Dec 2021 09:45:35 GMT

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' ))))

topic Qlik expression in App Development

Qlik expression

Re: Qlik expression