Lookup function

[Alonal148]

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

[lorenzoconforti]

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

[Alonal148]

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.

[lorenzoconforti]

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

[Alonal148]

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.

[lorenzoconforti]

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?