Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr() on the basis of max updated_date

Hi All,

Want to calculate total time spent on the basis of max updated_Date.

Show in text box and pivot table

Project idTimedateOutput in time
906:001/11/2016-
905:4510/11/20165:45
921:002/11/2016-
922:0530/11/20162:05
923:1015/11/2016-

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

Swati

1 Solution

Accepted Solutions
sunny_talwar

Attaching a sample

Capture.PNG

Also, You might need Interval instead of Time

Interval(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))

View solution in original post

2 Replies
sunny_talwar

Did you try this?

Time(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))

sunny_talwar

Attaching a sample

Capture.PNG

Also, You might need Interval instead of Time

Interval(Sum(Aggr(FirstSortedValue(Time, -date), [Project id])))

View solution in original post