topic Re: Re: Difference of dates in QlikView

Difference of dates

Anonymous — Fri, 07 Nov 2014 07:42:56 GMT

Hi,

I am attaching the application and suggest me on the same

Re: Difference of dates

Fri, 07 Nov 2014 08:03:04 GMT

Please see attached

Re: Re: Difference of dates

Anonymous — Fri, 07 Nov 2014 08:20:39 GMT

Hi,

Thanks Charles, this comes out good for this small data.

but I am not getting the accurate result for the large data

could you help me out on the same please. I am sharing the sample app.

Suggestions require from you

Re: Re: Difference of dates

Anonymous — Fri, 07 Nov 2014 08:42:34 GMT

Hi,

Thanks Charles, this comes out good for this small data.

but I am not getting the accurate result for the large data

could you help me out on the same please. I am sharing the sample app

Re: Re: Difference of dates

Anonymous — Fri, 07 Nov 2014 08:53:20 GMT

Hi,

Suggestions Required

Re: Re: Re: Difference of dates

salto — Fri, 07 Nov 2014 09:00:46 GMT

Hi,

added this to the end of the script:

SessionDef:

load *,

date(left(SessionIn,10),'MM/DD/YYYY') as Race Resident Session;

drop table Session;

rename table SessionDef to Session;

Hope this helps.

Re: Re: Re: Difference of dates

Fri, 07 Nov 2014 09:02:48 GMT

Try this one

Re: Re: Difference of dates

Anonymous — Fri, 07 Nov 2014 09:27:30 GMT

Hi Charles,

the values are not properly matching..

could you help me out a bit more pls

Re: Re: Difference of dates

Fri, 07 Nov 2014 09:35:30 GMT

Hi John,

Can you give me an example of the data that don't match.

thanks!

Re: Difference of dates

salto — Fri, 07 Nov 2014 09:37:58 GMT

Hi,

did you try my suggestion?

Re: Difference of dates

Anonymous — Fri, 07 Nov 2014 09:42:42 GMT

Hi SALTO,

Thnaks for your suggestion,

but it is not working ...

could you kindly go through the new data sheet and let me know

Re: Difference of dates

salto — Fri, 07 Nov 2014 09:59:15 GMT

Hi,

when you have read both excel files in tables First and Second, you need to rename and change the format of the field Job History Actual Start Timestamp like this:

TempSecond:

load *,

date(left([Job History Actual Start Timestamp],10),'MM/DD/YYYY') as CalendarDate Resident First;

drop table Second;

This way you have a relation between both fields.

Re: Difference of dates

Fri, 07 Nov 2014 10:05:08 GMT

Hi John,

Please see attached,

Re: Difference of dates

MK_QSL — Fri, 07 Nov 2014 10:12:28 GMT

time:

LOAD Name,

[Start Timestamp],

Date(Floor(Timestamp([Start Timestamp]))) as StartDate,

[End Timestamp],

Date(Floor(Timestamp([End Timestamp]))) as EndDate,

Status

FROM

Rank.xlsx

(ooxml, embedded labels, table is time);

Race:

LOAD RaceTime,

Rank

FROM

Rank.xlsx

(ooxml, embedded labels, table is Race);

Inner Join IntervalMatch(RaceTime) Load StartDate, EndDate Resident time;

Join (time) Load * Resident Race;

Drop Table Race;