Discussion Board for collaboration related to QlikView App Development.
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.
Thanks in Advance
In text box object... you can try this
=Avg(Aggr(FirstSortedValue(Value, -Date), Name, org, Year_Org))
When org = 12300 is selected
When org = 12301 is selected
Thanks a lot .. It worked
Thanks for your help...
I am glad we were able to help you