Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexbg1997
Contributor III
Contributor III

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,

alexbg1997
Contributor III
Contributor III
Author

Thank you Sunny!

This has worked.