Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
neetha_p
Honored Contributor

Re: Issue with expression

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
Highlighted
Partner
Partner

Re: Issue with expression

Hi Aditya,

check out the Qlikview Help for FirstSortedValue()

Andy

Highlighted
MVP
MVP

Re: Issue with expression

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)

Highlighted
neetha_p
Honored Contributor

Re: Issue with expression

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

Highlighted
Not applicable

Re: Issue with expression

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