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: 
Not applicable

Issue with expression

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

4 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Aditya,

check out the Qlikview Help for FirstSortedValue()

Andy

MK_QSL
MVP
MVP

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)

Anonymous
Not applicable
Author

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

Not applicable
Author

Thanks Neetha. It worked. Thanks for all the help.