Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
babud41
Contributor II
Contributor II

Qlik expression

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.

babud41_0-1639717946105.png

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

 

Kindly help

 

Regards,

Dinesh
India

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