topic If, Then, Else Statement with Multiple Conditions in Load in QlikView

If, Then, Else Statement with Multiple Conditions in Load

jmonroe918 — Fri, 03 Mar 2017 00:34:34 GMT

I am trying to create a load statement that populates a field called 'LateFlag' and want it to get filled with either on of 3 entries: "Not Applicable", "On-Time" and "Past-Due".

The conditions are as follows:

If 'Status' = "Issue Findings","Acknowledged", "Released" or "Closed"; Then enter "Not Applicable into 'LateFlag'.
If 'Status' = "Pending", "Scheduled" or "Execute" AND Today() is <= 'DateDue'; Then enter "On-Time" into 'LateFlag'.;
Else enter "Past-Due into 'LateFlag' (These are considered late).

The code statement I am trying is:

If(Audits.Status = 'Issue Findings' or 'Acknowledge' or 'Released' or 'Closed', 'Not App', if(Audit Status = 'Pending', 'Scheduled' or 'Execute' AND Today() <= DateDue, 'On-Time', 'Past-Due))

as AuditLateFlag

Which, I know the syntax is incorrect and I'm trying to search for the correct way to write it.

Any help is very much appreciated. Thanks.

Jeff

Re: If, Then, Else Statement with Multiple Conditions in Load

Anil_Babu_Samineni — Fri, 03 Mar 2017 03:38:10 GMT

Try this?

If([Audits.Status] = 'Issue Findings' or [Audits.Status] = 'Acknowledge' or [Audits.Status]= 'Released' or [Audits.Status] = 'Closed', 'Not App', if([Audit Status] = 'Pending', ([Audit Status] = 'Scheduled' or [Audit Status] = 'Execute') AND Today() <= DateDue, 'On-Time', 'Past-Due)) as AuditLateFlag

Make sure, With your date format of DateDue. Today() always gives 'DD-MM-YYYY'

Re: If, Then, Else Statement with Multiple Conditions in Load

jmonroe918 — Fri, 17 Mar 2017 18:48:23 GMT

Anil:

A bit late, but thanks for the solution. It worked great!

Jeff

Re: If, Then, Else Statement with Multiple Conditions in Load

Anil_Babu_Samineni — Sat, 18 Mar 2017 01:44:38 GMT

Glad it worked