Discussion Board for collaboration related to QlikView App Development.
How to compare the two line value and choose the min time.
e.g. I have a table below. When there are the same Case_ID, select the Min Arrival Time.
Result: When the Arrival Time is Min value, to calculate the Duration.
May be this:
(html, codepage is 1252, embedded labels, table is @1);
Left Join (Table)
Min(Arrival_Time) as Arrival_Time,
FirstSortedValue(Departure_Time, Arrival_Time) - Min(Arrival_Time) as Duration
Group By CASE_ID;
View solution in original post
I try your Function and it looks fine. Thanks a lot.