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.
Want to calculate total time spent on the basis of max updated_Date.
Show in text box and pivot table
Total time spent should be 7:50 (hh:mm)
I tried it,
max(aggr(sum(time),project,date)) but it showing incorrect 6:00+3:10=9:10
I have many field also in charts.
Some issue is facing in Aggr() kindly help.
Thanks in Advance
Attaching a sample
Also, You might need Interval instead of Time
Interval(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))
View solution in original post
Did you try this?
Time(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))