topic Re: Date difference in QlikView

Date difference

marco_puccetti — Thu, 18 Jun 2015 09:38:51 GMT

Hello i need to know how to make the difference between two date, in particular i need to get the avarage time diff in days from dates.

I have many date to compare so i need a fast solution\idea to make this.

Example:

Date 1

01/01/2015

02/04/2015

Date2

01/03/2015

02/04/2014

In this case i need to get the avarage days between all these date, any ideas?

Thanks

Marco

Re: Date difference

PrashantSangle — Thu, 18 Jun 2015 09:42:35 GMT

Hi,

Try

Interval(date2-date1,'D')

regards

Re: Date difference

MarcoWedel — Thu, 18 Jun 2015 10:09:48 GMT

Date2-Date1

(if dates already are numerical)

Date#(Date2,'MM/DD/YYYY')-Date#(Date1,'MM/DD/YYYY')

(if they are text)

Re: Date difference

marco_puccetti — Thu, 18 Jun 2015 10:16:05 GMT

This statement seems to work:

Num(Avg(Date(DT_APERTURA_CONTO) - Date(DT_RICHIESTA_APERTURA,'DD-MM-YYYY')),'##.##')

Isn't it?

Thanks

Marco

Re: Date difference

jagan — Thu, 18 Jun 2015 10:17:48 GMT

Hi,

Try like this

Num(Avg(DT_APERTURA_CONTO - DT_RICHIESTA_APERTURA),'##0.00')

Regards,

Jagan.

Re: Date difference

buzzy996 — Thu, 18 Jun 2015 10:25:27 GMT

try tis,

tab4:

Load

Date#(Date1,'DD/MM/YYYY') as Date11,

Date#(Date2,'DD/MM/YYYY') as Date22,

rornum;

Load * Inline [

Date1,Date2,rornum

01/01/2015,01/03/2015,101

02/04/2015,02/04/2014,102

];