using values from one table to select field from another table

Anonymous — Wed, 27 Jun 2018 03:28:50 GMT

Hello, greetings for the day.

how do i go about having the user select the field from one table from a listbox and use it to populate field from another table. below example where tables are not joined.

Table A

Name City1 Region

Peter New York US

Shawn London EU

Loren Boston US

Stacy New York US

Trace London US

Table B

City2 Value

New York 5

London 4

Boston 7

so the listbox would be for Name field where a user can select multiple values. based on it all tables in the sheet would filter on the corresponding city values. However it should only filter if name is selected from the listbox.

topic using values from one table to select field from another table in QlikView

using values from one table to select field from another table