Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
justcotto
Contributor III
Contributor III

If a response time is 2 days and submitted before 1PM is should constitute as a yes.

I have a script that I have implemented:

if([PAYMENT_GROUP_CODE]='Urgent',if([Response Time]<= '2', 'Yes', 'No'), if([Response Time]<=3, 'Yes', 'No')) AS [SLA Met],

I have another field called 'Approval Time'.  I want to also implement, [Approval Time]<'13:00'.  If a response time is 2 days and submitted before 1PM is should constitute as a yes.  

1 Reply
crusader_
Partner - Specialist
Partner - Specialist

Hi,

Try something like below (depend on [Approval Time] field format):

if([PAYMENT_GROUP_CODE]='Urgent',if([Response Time]<= 2 AND [Approval Time]<13/24, 'Yes', 'No'), if([Response Time]<=3, 'Yes', 'No')) AS [SLA Met]

//Andrei