Last appeared number on certain date

[Sally3]

Hi Everyone, 

I am trying to create chart that can show the last appeared number on certain date. 

I have 2 columns, one contains dates and one contains values, I need expression that shows the value on the last existing date(maximum date).

something similar to Excel Function  =VLOOKUP(MAX(B3:B26),B2:D26,3,FALSE) 

can anyone help me with that?

Kind Regards

[joaopaulo_delco · Accepted solution]

Hi @Sally3 !

      The way to solve your problem is using the FirstSortedValue() function.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/BasicAg...