Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sindus123
Contributor III
Contributor III

Latest value for each year

Hi Everyone,


I want to include two years of data into the report and i need to find latest value based on date column for each particular year.

For 2018 the latest value is 3000. For 2017 latest value is 1000.

 

Rec NoNameDateValue
1A1/1/20181000
2A1/2/20182000
3A1/3/20183000
4A1/1/20171000
5A1/2/20173000
6A1/3/2017

1000

Thanks in Advance

13 Replies
sunny_talwar

In text box object... you can try this

=Avg(Aggr(FirstSortedValue(Value, -Date), Name, org, Year_Org))

When org = 12300 is selected

Capture.PNG

When org = 12301 is selected

Capture.PNG

sindus123
Contributor III
Contributor III
Author

Thanks a lot .. It worked

sindus123
Contributor III
Contributor III
Author

Thanks for your help...

sunny_talwar

I am glad we were able to help you