topic Re: HELP! Complex expression assistance needed! in QlikView

HELP! Complex expression assistance needed!

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

Hi All,

I am trying to calculate a value for an existing column called 'Performance' by using two dates. The requested date of delivery, and the actual date of delivery. If the line was delivered before the requested delivery date the value needs to list 'EARLY' . If the same day it needs to list 'ON TIME'. If the line was delivered after the requested delivery date the value needs to list 'LATE'.

Requested Delivery Date	Actual Delivery Date	Performance
01/01/2018	10/01/2018
20/01/2018	10/01/2018
30/01/2018	15/01/2018

This table is a perfect match to my data set, however I am struggling to write the expression that would populate the 'Performance' Column. Can anyone help?

Thank you for reading

Alex.

Re: HELP! Complex expression assistance needed!

YoussefBelloum — Fri, 11 May 2018 09:28:02 GMT

Hi,

you want to create the field performance on the model or just use it as an expression in a chart ?

Re: HELP! Complex expression assistance needed!

Anonymous — Fri, 11 May 2018 09:31:12 GMT

Hi Youssef,

I would like to populate the field in the data model.

Thanks

Re: HELP! Complex expression assistance needed!

Anil_Babu_Samineni — Fri, 11 May 2018 09:34:38 GMT

May be this?

Load [Requested Delivery Date],

[Actual Delivery Date],

If([Requested Delivery Date] < [Actual Delivery Date], 'EARLY',

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

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

From Table;

Re: HELP! Complex expression assistance needed!

YoussefBelloum — Fri, 11 May 2018 09:35:01 GMT

PFA

Re: HELP! Complex expression assistance needed!

Anonymous — Fri, 11 May 2018 09:53:27 GMT

Brilliant!

This has worked!

Thanks you all for your help!

Re: HELP! Complex expression assistance needed!

Anil_Babu_Samineni — Fri, 11 May 2018 10:05:16 GMT

Great, Can you mark "Correct Answer" of right response !!