topic Re: How can I compare date (lines) in QlikView

How can I compare date (lines)

suzel404 — Mon, 07 Apr 2014 04:06:57 GMT

Hi all,

I want to identify the delay between each line of the START_DATE. I use Peek function but I don't know how can obtain the good result.

LOAD* INLINE [
ID_STORE, END_DATE, BRAND_CODE, STORE, START_DATE, CLOSING_DATE
6888, 04/01/2014 13:01:12, H221, 545, 26/12/2013 00:00:00, 26/12/2013 00:00:00
6888, 04/01/2014 13:01:12, H222, 545, 26/12/2013 14:24:00, 27/12/2013 06:21:00
6888, 04/01/2014 13:01:12, H223, 545, 27/12/2013 12:53:00, 27/12/2013 12:54:12
6888, 04/01/2014 13:01:12, H224, 545, 04/01/2014 00:00:00, -
6888, 04/01/2014 13:01:12, H225, 545, 24/01/2014 15:19:56, 24/01/2014 15:19:56];

Delay = Delay in lines (START_DATE) : lines 2 - lines 1

Line 1 : 26/12/2013 00:00:00 -

Line 2 : 26/12/2013 14:24:00-

Line 3 : 27/12/2013 12:53:00-

Line 4 : 04/01/2014 00:00:00-

Line 5 : 24/01/2014 15:19:56-

Thanks for your help.

Re: How can I compare date (lines)

sujeetsingh — Mon, 07 Apr 2014 04:53:25 GMT

Try this

http://community.qlik.com/thread/64992

Re: How can I compare date (lines)

rohit214 — Mon, 07 Apr 2014 04:58:00 GMT

hi,

You can use peek, previous ,above function.

peek and previous function youo can use in backend but above function in frontend in any table.

peek([field name],0)

thanks

rohit

Re: How can I compare date (lines)

Mon, 07 Apr 2014 05:09:31 GMT

Hi,

Find the atatchment

Re: How can I compare date (lines)

sujeetsingh — Mon, 07 Apr 2014 05:10:56 GMT

See this sample

Re: How can I compare date (lines)

amit_saini — Mon, 07 Apr 2014 05:27:37 GMT

Hi ,

Please try this:

=Interval(Date1-Date2,'d hhmm:ss') ----->>> For calculating difference

=Year(Date1) - Year(rDate2)--->>>>For Year Difference Calculation.

Thanks,

Re: How can I compare date (lines)

arjunkrishnan — Mon, 07 Apr 2014 07:33:46 GMT

Hai Joshu

Use This Expressin In Back EnD...It Will Working Fine to Compare The Date on Same Column...

=Interval(Date(START_DATE,'DD/MM/YYYY hh:mm:ss')-Date(Peek(START_DATE),'DD/MM/YYYY hh:mm:ss'),'DD hh:mm:ss') AS INRERVAL

Re: How can I compare date (lines)

suzel404 — Wed, 09 Apr 2014 04:35:30 GMT

Hi all,

Sorry for my delay. Really!!

Thanks you at all, the solution proposed works well.

Thanks you.