topic Re: VLOOKUP with terms in Qlik in App Development

VLOOKUP with terms in Qlik

Larsstoel — Fri, 29 Sep 2023 11:55:06 GMT

I created a visual with the columns transport zone and departure day.
These two columns both come from a different table but are linked by a field that exists in both tables.

I have a third table where each transport zone has the departure time. It may be that a transport zone has multiple departure days and therefore the transport zone must be matched with the departure day to get the correct departure time from the third table.

Does anyone have an idea how I can set this up in Qlik?

Thanks in advance for thinking with me.

Re: VLOOKUP with terms in Qlik

JHuis — Fri, 29 Sep 2023 14:18:34 GMT

you could use mapping:

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/Mapping.htm

Re: VLOOKUP with terms in Qlik

rwunderlich — Sat, 30 Sep 2023 11:09:51 GMT

Does the third table have a departure day field? Can you post a brief example of your table fields eg

Table1: Zone, Departure Day

-Rob