Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Performance calculation expression

Hello All,

I have entered the following script which gives me the performance I need for Early, On time, and late deliveries, however I now need a line of script that says if there is no 'Actual GI Date' performance should list 'Undelivered late', any ideas?

     If([Requested date] < [Actual GI Date], 'EARLY',

     If([Requested date] < [Actual GI Date], 'On Time',

     If([Requested date] > [Actual GI Date], 'LATE'))) as Performance,

Can anyone help? I am assuming it is something along the lines of:

If ([Actual GI Date] = 'BLANK', 'UNDELIVERED LATE') as Performance

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this

    

If(Len(Trim([Actual GI Date])) = 0, 'UNDELIVERED LATE',

If([Requested date] < [Actual GI Date], 'EARLY',

If([Requested date] = [Actual GI Date], 'On Time',

If([Requested date] > [Actual GI Date], 'LATE')))) as Performance,

View solution in original post

3 Replies
avkeep01
Partner - Specialist
Partner - Specialist

IF(LEN([Actual GI Date])=0,'Undelivered late') AS Performance


sunny_talwar

May be this

    

If(Len(Trim([Actual GI Date])) = 0, 'UNDELIVERED LATE',

If([Requested date] < [Actual GI Date], 'EARLY',

If([Requested date] = [Actual GI Date], 'On Time',

If([Requested date] > [Actual GI Date], 'LATE')))) as Performance,

Anonymous
Not applicable
Author

Thank you Sunny!

This has worked.