topic Re: Lookup function in App Development

Lookup function

Alonal148 — Sat, 16 Nov 2024 03:12:39 GMT

Hello,

The lookup function bellow is not working.

The message I got from Qlik is:

The function is: Lookup ([High],[date],MonthsStart(1,[diffDate]),[Tariff TOU Low]) as [Tariff pisga]

And I lookup the value [High] from the bellow table:

I do not understand why the massage from Qlik is : "The value not found"

Thank you,

Alona

Re: Lookup function

lorenzoconforti — Thu, 20 Feb 2020 15:52:33 GMT

You need to provide the field name as a string (in quotes)

Lookup ('High','date',MonthsStart(1,[diffDate]),'Tariff TOU Low') as [Tariff pisga]

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/LookUp.htm

Re: Lookup function

Alonal148 — Wed, 26 Feb 2020 06:44:52 GMT

Hi,

Thank you for your help.

The function is still not working.

I opend new script for the "Vlookup". The script load is O.K, But the new value which I wanted to create from the Vlookup is empty. It's values are zero.

Re: Lookup function

lorenzoconforti — Wed, 26 Feb 2020 06:49:30 GMT

The third parameter needs to be without single quotes. Also, be mindful what you have now posted is different from the original post

Re: Lookup function

Alonal148 — Wed, 26 Feb 2020 07:18:07 GMT

Hello,

I changed the parmeters becouse the function did not worked and I wanted to try new parameters to see if that is the problem.

I canceled the quots but it still zero.

Re: Lookup function

lorenzoconforti — Wed, 26 Feb 2020 07:24:06 GMT

The syntax should be correct. Can you post a screenshot of how the script looks like now?

Are you sure, based on the data you have, that you have matched results?