Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
Partner

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