topic Re: Getting new date field withexisting two dates -please help in QlikView

Getting new date field withexisting two dates -please help

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

Re: Getting new date field withexisting two dates -please help

qlikapple — Fri, 12 Jul 2019 08:13:50 GMT

Alt date	Targ date	No
1-Aug-18	2-Aug-18	12
	3_aug-2018	123
4-Aug-18		12345
		1234567
6-Aug-18	7-Aug-18	123123
	8-Aug-18	1212

Now the Requirement is

Introduce new field call due date where the logic will be like below
a) If “Alt date” field is blank, then it captures the “Targ date” in the “due date” field.
b) If “Alt date” field has an entry, then it captures the “Alt date” in the “Due date” field.
c) If “Alt date” field and “Targ date” field are both populated, then it captures “Alt date” in the “Due date” field.

Re: Getting new date field withexisting two datesca -please help

qlikapple — Fri, 12 Jul 2019 08:53:00 GMT

can anyone please check and help

Re: Getting new date field withexisting two dates -please help

qlikapple — Fri, 12 Jul 2019 13:41:18 GMT

hi anyone please check and help

Re: Getting new date field withexisting two dates -please help

Akhil_Reddy — Fri, 12 Jul 2019 14:53:16 GMT

load
altdate,
targdate,

if( altdate <> null() and targdate <> null(),altdate,
if( altdate = null() ,targdate,

if( altdate <> null() ,altdate) ))as duedate,
no

Re: Getting new date field withexisting two dates -please help

Brett_Bleess — Wed, 07 Aug 2019 12:39:53 GMT

Did the poster's comment help you resolve things? If so, please be sure to give them credit by clicking the Accept as Solution button on their post. If not, please leave an update on where things stand.

Regards,
Brett