Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

VLookup (Or equivalent) in Qlik Sense

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

7 Replies
Partner
Partner

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;

Specialist
Specialist

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

Thanks.

Partner
Partner

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

Partner
Partner

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.

Specialist
Specialist

Why don't you use lookup function or applymap?

Partner
Partner

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;

Creator III
Creator III

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