Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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

Highlighted
New Contributor II

Re: Sum FirstSortedValue for Groups

Hello,

thank you for your help. It works 🙂