Qlik script function similar to LOOKUP() in Tableau

[Vibha]

Is there a function in qliksense which is similar to the LOOKUP() function in tableau? 

[RsQK]

Hi, these both are:

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

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

[sidhiq91]

@Vibha  There are 2 functions in qlik sense.

1. Applymap() Function.

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

2. Lookup () Function.

https://community.qlik.com/t5/Design/A-Look-at-the-Lookup-Function/ba-p/1469705 

[Vibha]

Hi, 

Is there a similar function in script? 

[RsQK · Accepted solution]

Yes - these are

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordF...

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordF...

the table you're loading has to be sorted in the way you want to see - then using these functions will help you achieve what you need.