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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum(Amount) with lastest version of every Key

Hi Guys,

can you tell me, how can I use sum(Amount) by KeyNr, within the last version of it in backend?

I want for example sum(amount) all KeyNr from periode january to july ..

like:

sum(amount)->within only max(version)

10 Replies
maxgro
MVP
MVP

sum(aggr(subfield(concat(Aggr(sum(Amount), KeyNr, VersH), '@', -VersH), '@', 1),  KeyNr))