Qliksense straight table order by measure change

[krmvacar]

Hi All,

I have a Straight table and when I press sort by each field, the total data changes. Here, I want my total data not to change, and I just want it to be sorted alphabetically according to the WORKEND field.When I use the aggr function, the total data changes. It gives wrong results.
your help is requested. qvf is attached

I want it to look like this even when my total value is pressed to rank.

Best Regards

[JHuis]

Hi change the measure to: (Workend-Workstart)*1440

Then nothing changes anymore!

[krmvacar]

hi @JHuis 

its not working.  I think you misunderstood my question

[GeorgePhilips23 · Accepted solution]

Aggregating the Intervals shall solve the problem!

Num(Num#(

Aggr(

if(

Interval(Workend - Timestamp(RangeMax(Above(total Workend,0,3))))<0,

0,

Interval(Workend - if(Workstart<Above(Total Workend),Above(Total Workend),Workstart),'mm')

)

,(Workend,Numeric,Ascending))

))

[krmvacar]

hi @GeorgePhilips23 

its working thank you so much