topic Re: Min In DateTime & Max Out DateTime against Distinct TicketID in the Best Possible Way in QlikView

Min In DateTime & Max Out DateTime against Distinct TicketID in the Best Possible Way

aveeeeeee7en — Thu, 16 Oct 2014 10:21:58 GMT

Hi All

I have to find Min In DateTime & Max Out DateTime against Distinct TicketID

Below I am using the Code to find Min & Max Date.

My Questions are:

1) Is the code I am using is the correct way

2) Is there any other alternate way

3) Can I use First Sorted Value

See my Code:

Table:
LOAD TicketID,
SerialNumber,
CreationDateTime
FROM

(qvd);

Left Join

LOAD TicketID,
InDateTime
FROM

(qvd);

Left Join(Table)

LOAD TicketID,
ENG_OUT_TIME
FROM

(qvd) WHERE MATCH(UPPER(STATUS),'CLOSED','TELE CLOSURE','MACHINE UNDER OBSERVATION');

PFA.

Regards

Av7eN

anbu1984 — Thu, 16 Oct 2014 10:26:16 GMT

You can use FirstSortedValue to get min and max date

aveeeeeee7en — Thu, 16 Oct 2014 10:54:38 GMT

First Sorted Value is nice But the Code I am using is the right Approach or not.

Kindly Suggest.

Anonymous — Thu, 16 Oct 2014 11:10:14 GMT

Hi,

Use the code like in the attachments...

anbu1984 — Thu, 16 Oct 2014 11:18:00 GMT

If you don't need other than Min value, then you calculate Min before Join

LOAD TicketID,

Min(InDateTime)

FROM

(qvd)

Group By TicketID;