Max Date Value with in Year

[h_prakash]

Hello Experts,

I have a requirement where I need to show amount for the maxdate with in each year. This is in the front end side.

The Data is like in the backend.

Year   Date                 Amount

2017  01/01/2019    100

2017  05/01/2019    200

2017  11/01/2019    150

2018  03/01/2019    400

2018  05/01/2019    500

2019  08/01/2019    600

2019  12/01/2019    100

I need to create a Table Chart where I need to show the amount where the date is maximum for that year.

Year   Amount

2017   150

2018    500

2019    100

Thanks

Hari

[rwunderlich · Accepted solution]

Dimension: Year

Measure: Max(aggr(sum(Amount), Date))

-Rob

[h_prakash]

Thanks Rob for replying will try that. When we will use Firstsortvalue function?

[rwunderlich]

Use FirstSortValue when you want to return a value based on the rank of another value, for example if  you want the Date on which the max Amount occurred:

FirstSortedValue(Date, -Max(aggr(sum(Amount), Date)))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com