Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nici_prm
Contributor
Contributor

How to filter the latest value of one data entry

Hey,

I already searched for my problem, but I couldn't make it work.

I have this table what you see on the bottom. I have to build the sum of amount but just the latest value. 

E.G. : Material-No 26 had in 2011 an amount of 0 and Mat-No 384 in May 2005 an amount of 3 so the sum is 3. every other amount for the same materialnumber that is earlier is no longer relevant. My problem is that I just can take the newest value of every material-no and need to build a sum. 

Material-NoYearMonthAmountValue
2620091210,00080,00
262010125,00020,00
26201120,0000,00
3842003120,0000,00
3842004120,0000,00
384200553,0000,00
8862003120,0000,00
8862004120,0000,00
886200580,0000,00
37032009120,0000,00
37032010120,0000,00
3703201140,0000,00
95412003120,0000,00
95412004120,0000,00
95412007121,00015,00
95412008121,00015,00
9541200981,00015,00
96212003120,0000,00
96212004120,0000,00
96212007121,00015,00
96212008121,00015,00
9621200981,00015,00
96312003120,0000,00
96312004120,0000,00
96312007121,00015,00
96312008121,00015,00
3 Replies
chrismarlow
Specialist II
Specialist II

Hi,

I think you need to use FirstSortedValue, so something like the attached (you may need to do something about year/month & aggregation, depends on your underlying data).

Cheers,

Chris.

nici_prm
Contributor
Contributor
Author

I already tried this, but I couldn't make it work, this is why i am asking.

chrismarlow
Specialist II
Specialist II

Hi,

Maybe if you share some screenshots of what is not working that would help.

Cheers,

Chris.