Discussion Board for collaboration related to Creating Analytics for QlikView.
I have following issue to solve... I just want the rows with minimum time.
I have data looks like the following table:
I have starting write a script like this:
if(peek('OrderId')=OrderId, if(peek('Time)<Time, peek(Time),Time),Time) as Testing
My result is like Table1 nothin is change.
Thx in advance!!!
Go to Solution.
min(fabs(TimeField )) as Testing
FROM Table1 Group by OrderId ;
Try this Scipt
Use this Script get ur Result
min(Time) as Testing
min(0+Time) as Time
Group By OrderId;
drop Table table1;
Thx for quick response!
But why I still don't get my minimum value from column 'TIME'.
My basis table look like this:
As result I want:
How I can handle the negative time value in column 'Diff Time' ????
Maybe that is my problem.
THX IT WORKS!!!!