Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
ahmada
New Contributor II

Sum FirstSortedValue for Groups

Hello,
I am new in the community and hope you can help me. I have a table with article numbers, storage locations and quantities.

I would like to sum the values from the last date regarding the article number and the storage location. I can't get it to work.

I tried to sum with FirstSortedValue(Menge, -Datum). But unfortunately it doesn't work.

I hope you can help me. (Lager = Storage Location, Menge = Quantity)

 

Articles.PNG

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Sum FirstSortedValue for Groups

Hello,

Check this out

write this in your measure and also check the attachment it is the desired output.

FirstSortedValue(Aggr(Sum(Quantity),ArticleNumber,StorageLocation),-Date)

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Sum FirstSortedValue for Groups

Hello,

Check this out

write this in your measure and also check the attachment it is the desired output.

FirstSortedValue(Aggr(Sum(Quantity),ArticleNumber,StorageLocation),-Date)

View solution in original post

ahmada
New Contributor II

Re: Sum FirstSortedValue for Groups

Hello,

thank you for your help. It works 🙂