Excel XLOOKUP equivalent

[danielworthington]

Hi there,

I'm new to using Qlik Sense, I have a licence that allows me to edit sheets that are built already so I don't have access to the data stream or the deeper coding. So I can edit sheets and add in functions etc in the graphical builder.

I'm looking to see if there's a function similar to Excel XLOOKUP that will search from the bottom first on a table column.

Thanks!

Dan

[Chanty4u · Accepted solution]

You can use applymap function which is similar to lookup

https://community.qlik.com/t5/QlikView-App-Dev/quick-applymap-example/td-p/515616