Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Regards,
Sachin
Hi Aditya,
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)
Regards
Neetha
Hi Aditya,
check out the Qlikview Help for FirstSortedValue()
Andy
What do you mean by latest score?
If you have date or timestamp against each score, you can use as below
Straight Table
Dimension
[Transaction ID]
Expression
FirstSortedValue(Score,-Date)
or
FirstSortedValue(Aggr(SUM(Score),Date,[Transaction ID]),-Date)
Hi Aditya,
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)
Regards
Neetha
Thanks Neetha. It worked. Thanks for all the help.