Skip to main content
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Replicate the behaviour of table Total with FirstSortValue


I have a measure in a table with the FirstOrderValue.

I've set the total function to sum, and it works fine.


Now I'm setting another table with only the sum of some measure, included the one discussed above, but when I try to do something like this: sum(Aggr(FirstSortedValue(operative_agreed, -period_date), intermediary)) the result differs (by a lot) with the total in the other table, where the measure is FirstSortedValue(operative_agreed, -period_date).

intermediary here is the first dimension I used in the other table.


What's the issue here?



Labels (2)
0 Replies