topic Calculating data in same column in QlikView

Calculating data in same column

Fri, 25 May 2012 09:07:03 GMT

Hi Guys, I need to calculate days in a column of dates for example :-

10/01/2012

31/03/2012

05/04/2012 etc.

The problem I have is that in the QVD I load, all the dates in the same column have the same field name. How do I calculate the number of days between the two different dates in this instance.

Paul.

Re: Calculating data in same column

giakoum — Fri, 25 May 2012 09:43:41 GMT

[test]:

LOAD * INLINE [

10/01/2012

31/03/2012

05/04/2012

];

[test2]:

LOAD

,previous(F1) as PF1

,date#(F1, 'DD/MM/YYYY') - Date#(Previous(F1), 'DD/MM/YYYY') as F2

Resident [test];

make sure you order them correctly during load