Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ernesto_Granadillo
Contributor
Contributor

Capture the last loaded value

Hi,

It is necessary to capture the last loaded value (objective) for a specific dimension and add those values ​​to have a total of the loaded values ​​(total objective).

The following statement is being used, but it is not taking the last loaded value:

• Sum (Aggr (Max ({1} [58]), PUBLIC_ID)).

Labels (1)
2 Replies
Anil_Babu_Samineni

May be

FirstSortedValue(PUBLIC_ID, Aggr(Max({1} [58]), PUBLIC_ID))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Ernesto_Granadillo
Contributor
Contributor
Author

It worked to place the value of each sales manager, but it does not seem to me for the total of the values ​​that are displayed.

Display attached image.