Max date price over a year

pirotfab — Tue, 12 Jul 2022 06:38:21 GMT

Hello,

I have a database with prices depending on a date.
I would like to obtain, for each item, the price for the last date of the year.
Can you help me ?
Attached is an Excel example

Fabien

thanks

Re: Max date price over a year

MayilVahanan — Tue, 12 Jul 2022 08:16:28 GMT

Try like below

LY: FirstSortedValue({<caldate={">=$(=Date(YearStart(Max(caldate),-1),'DD-MM-YYYY'))<=$(=Date(YearEnd(Max(caldate),-1),'DD-MM-YYYY'))"}>}pua, -caldate)

TY: FirstSortedValue(pua, -caldate)
or
FirstSortedValue({<caldate={">=$(=Date(YearStart(Max(caldate)),'DD-MM-YYYY'))<=$(=Date(YearEnd(Max(caldate)),'DD-MM-YYYY'))"}>}pua, -caldate)

topic Re: Max date price over a year in QlikView

Max date price over a year

Re: Max date price over a year