This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
My trip data contains the following:
and loads of other fields, the table also links to various other tables, but:
I need to calculate the Total Time Stopped. I was thinking of using the Next TripStartTimeDate - Current TripEndTimeDate to get the answer.
I just cannot get the correct function to use, both Peek() and Previous() looks backwards and there is no Next() function to look forward into the data.
This data needs to be presented by Date, Customer and Vehicle
Hope you can help
Current TripStartTimeDate - Previous TripEndTimeDate
should give you exactly the same result ....
you may for example:
a) add rowno() as id innto first table
b) join with load Current TripStartTimeDate - Previous TripEndTimeDate, row() -1 as id from your table
You are in the right path
If you need to calculate the time stopped by vehicle Order your table by date and vehicle then use peek and previous
To evaluate next record to identify the last record of each vehicle by date there is a sample in the community
When I arrive to my office I can find it for you
Sent from my iPhone