Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sally3
Contributor III
Contributor III

Last appeared number on certain date

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) 

doc-excel-find-value-with-latest-date-01.png

can anyone help me with that?

 

 

Kind Regards

1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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...

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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...

Help users find answers! Don't forget to mark a solution that worked for you!