Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Larsstoel
Contributor II
Contributor II

VLOOKUP with terms in Qlik

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.

Labels (1)
2 Replies
JHuis
Creator III
Creator III

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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