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

Replicate the behaviour of table Total with FirstSortValue

Hi,

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?

Thanks

 

Labels (2)
0 Replies