Discussion Board for collaboration on QlikView Scripting.
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, CreationDateTimeFROM(qvd);
LOAD TicketID, InDateTimeFROM(qvd);
LOAD TicketID, ENG_OUT_TIMEFROM(qvd) WHERE MATCH(UPPER(STATUS),'CLOSED','TELE CLOSURE','MACHINE UNDER OBSERVATION');
You can use FirstSortedValue to get min and max date
First Sorted Value is nice But the Code I am using is the right Approach or not.
Use the code like in the attachments...
If you don't need other than Min value, then you calculate Min before Join
Group By TicketID;