topic How to add a DateDiff in the load script in QlikView

How to add a DateDiff in the load script

Wed, 29 Dec 2010 17:23:18 GMT

Apologies, I'm a newbie to QV!!

I'm trying to add a DateDiff field in the load script, as the piece of code below is giving me nulls,1,2 and3+ but nothing in the 3 group and I just want to see why.

The DateDiff needed is a fixed date of 01-Nov-10 - {ACW Last Requal Date], would anyone be able to point me in the right direction please?

Thanks

Nic

If(IsNull([ACW Last Requal Date]),'',

If('01/11/2010'-[ACW Last Requal Date] < '366','1',

If('01/11/2010'-[ACW Last Requal Date] < '731','2',

If('01/11/2010'-[ACW Last Requal Date] < '1096','3',

If('01/11/2010'-[ACW Last Requal Date] > '1095','+3'))))) AS [ACW Last Requal Year],

How to add a DateDiff in the load script

vgutkovsky — Wed, 29 Dec 2010 17:31:35 GMT

Your syntax is mostly right, just change it to: If(date#('01/11/2010','DD/MM/YYYY') - [ACW LAST Requal Date] etc.

How to add a DateDiff in the load script

hector — Wed, 29 Dec 2010 17:50:51 GMT

Hi, my version is with makedate()


If(makedate(2010,11,1) -[ACW Last Requal Date .........

By the way, it seems you are trying to generate "years of something" (LOL xD), maybe you can use an intervalmatch() instead of nested if's

Rgds