topic Re: Performance calculation expression in QlikView

Performance calculation expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Performance calculation expression

avkeep01 — Wed, 30 May 2018 12:20:08 GMT

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

Re: Performance calculation expression

sunny_talwar — Wed, 30 May 2018 12:21:11 GMT

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,

Re: Performance calculation expression

Anonymous — Wed, 30 May 2018 12:35:10 GMT

Thank you Sunny!

This has worked.