topic Re: VLookup (Or equivalent) in Qlik Sense in App Development

VLookup (Or equivalent) in Qlik Sense

richardm90 — Thu, 31 May 2018 13:35:11 GMT

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')

Re: VLookup (Or equivalent) in Qlik Sense

avkeep01 — Thu, 31 May 2018 13:37:56 GMT

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;

Re: VLookup (Or equivalent) in Qlik Sense

isingh30 — Thu, 31 May 2018 13:47:28 GMT

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

Thanks.

Re: VLookup (Or equivalent) in Qlik Sense

richardm90 — Thu, 31 May 2018 16:08:28 GMT

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

Re: VLookup (Or equivalent) in Qlik Sense

richardm90 — Thu, 31 May 2018 16:09:39 GMT

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.

Re: VLookup (Or equivalent) in Qlik Sense

isingh30 — Thu, 31 May 2018 17:37:10 GMT

Why don't you use lookup function or applymap?

Re: VLookup (Or equivalent) in Qlik Sense

avkeep01 — Thu, 07 Jun 2018 07:04:38 GMT

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;

Re: VLookup (Or equivalent) in Qlik Sense

kaanerisen — Thu, 07 Jun 2018 08:55:18 GMT

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/LookUp.htm