Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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;
What exactly is your requirement? Are you trying to learn v lookup in qlik sense.
Thanks.
Thank you, I need to lookup against existing places already in tables I have uploaded to the system though, will this work for this?
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.
Why don't you use lookup function or applymap?
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;
You can definitely use lookup function to search some data on other tables. Even you can search on current table.