Selecting fields in one table based on selected fields from another table
I have a question that seems fairly straightforward but is giving me a headache.
I have two straight tables in my Qlikview dashboard with dimension fields that I would like to link together. Each dimension comes from a different data source, but they share many of the same values.
Is there an easy way to link these dimensions together? I would like to be able to select an individual/range of values from one table and have that same individual/range be selected in the other table.
I tried linking these two tables together by using a join statement in the script, but that did not seem to work.
The two tables I am trying to link are in the screenshot below. The dimension is labeled 'Route'.
Seems like a data modelling issue that is similar to when you have multiple dates.
You could add a link table with values from both. You would use Route1 and Route2 in the respective charts, but use 'Route' as a list box to select a route that you want to filter both tables on 1 or more route values.
Is this enough to help ? ps: it doesn't take into account how these tables are joined currently in your model which is important. You may need to post your table view diagram