VLookup (Or equivalent) in Qlik Sense

[richardm90]

Hi All,

I can't seem to find the ability to use a VLookup in Qlik Sense to match the name of places to particular codes.

The only way I can see to do this currently is via if statements, i.e.....

=if([Place]='London','LON')

[avkeep01]

Hi Ric, you can create an mapping table with an inline table below:

MAP_RenamePlaces:

MAPPING LOAD * INLINE [

Place, New Name

Londen, LON

];

And in your table you can apply the mapping by adding an field

YouTable:

LOAD

APPLYMAP('MAP_RenamePlaces',Place) AS Place_Renamed,

*

FROM YourTable;

[isingh30]

What exactly is your requirement? Are you trying to learn v lookup in qlik sense.

Thanks.

[richardm90]

Thank you, I need to lookup against existing places already in tables I have uploaded to the system though, will this work for this?

[richardm90]

Yes, Exactly, I understand VLookup in general just unsure how to apply it in Qlik Sense. The list of places I have is already in tables within my Qlik Sense App, I just need to match them against specific codes and output those matching codes into a column.

[isingh30]

Why don't you use lookup function or applymap?

[avkeep01]

Hi Ric,

Instead of using an inline table you can also use a FROM table (from your database or excel files)

MAPPING LOAD

Place,

New Name

FROM YourSourceTable;

[kaanerisen]

You can definitely use lookup function to search some data on other tables. Even you can search on current table.

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/InterRecordFunctions/Lo...