topic help with date in QlikView

help with date

fdelacal — Wed, 17 Jul 2013 10:19:20 GMT

i have fiedl date_ini that look like

11/11/2007

26/11/2007

28/11/2007

21/03/2008

26/11/2008

16/01/2009

26/11/2009

30/07/2013

now i need do te finish day for this dates

example

start date finish day

11/11/2007 25/11/2007 26/11/2007 - 1

26/11/2007 27/11/2007 28/11/2007

28/11/2007 20/03/2008 21/03/2008

21/03/2008 25/11/2008 26/11/2008

i need do that in script for late do a intervalmatch with other date field.

Thanks

Re: help with date

kaushiknsolanki — Wed, 17 Jul 2013 10:48:51 GMT

Try this.

DATA:

Load Date(Date#(STARTDATE,'DD/MM/YYYY')-1) as EndDate,Previous(Date(Date#(STARTDATE,'DD/MM/YYYY'))) as StartDate inline [

STARTDATE

11/11/2007

26/11/2007

28/11/2007

21/03/2008

26/11/2008

16/01/2009

26/11/2009

30/07/2013

];

Regards,

Kaushik Solanki

Re: help with date

fdelacal — Wed, 17 Jul 2013 11:12:55 GMT

original data

DATE QT

11/11/2007 7

26/11/2007 1

28/11/2007 1

21/03/2008 8

26/11/2008 30

16/01/2009 8

26/11/2009 6

11/07/2013 3

RESULT with your suggest.

STARTDATE ENDDATE QTSTOCK

26/11/2007 10/11/2007 7

28/11/2007 25/11/2007 1

21/03/2008 27/11/2007 1

26/11/2008 20/03/2008 8

16/01/2009 25/11/2008 30

26/11/2009 15/01/2009 8

11/07/2013 25/11/2009 6

10/07/2013 3

shoul be..

STARTDATE

ENDDATE QTSTOCK

11/11/2007 25/11/2007 7

26/11/2007 27/11/2007 1

28/11/2007 20/03/2008 1

21/03/2008

25/11/2008 8

thanks

Re: help with date

kaushiknsolanki — Wed, 17 Jul 2013 12:05:53 GMT

Hi,

Load Date(Date#(DATE,'DD/MM/YYYY')-1) as EDATE,Date(Date#(Previous(DATE),'DD/MM/YYYY')) as SDATE,QT inline [

DATE, QT

11/11/2007, 7

26/11/2007, 1

28/11/2007, 1

21/03/2008, 8

26/11/2008, 30

16/01/2009, 8

26/11/2009, 6

11/07/2013, 3

] where not isnull(Date(Date#(Previous(DATE),'DD/MM/YYYY')));

Regards,

Kaushik Solanki