Discussion board where members can get started with QlikView.
Can someone please help me with this requirement.
I have multiple records of "Paynet Construction Score" for each "Transaction ID". But I want to show only the latest Paynet Construction Score record for each Transaction ID.
Thank you in advance.
Use aggr functions to grouping data based on dimension [Transaction ID] and Date.
and firstsortedvalue function for getting higest or lowest value for [Paynet Construction Score] .
=FirstSortedValue(Aggr(SUM([Paynet Construction Score]),Date,[Transaction ID]),-Date)
View solution in original post
check out the Qlikview Help for FirstSortedValue()
What do you mean by latest score?
If you have date or timestamp against each score, you can use as below
Thanks Neetha. It worked. Thanks for all the help.