I am new to Qlikview and would like to know how to get the following scenario to work.
Basically when I select the Airport I am really selecting the "Destination Airport". I want to be able to use this value and get the destination airports that this Airport id the Origin Airport as well.
The above data is a mock up, so the field names might not might ot make sense.
This is a simple model of the data
I tried a few things and I can get the value I want to use as a filter from this: Subfield(GetCurrentSelections([DestAirport]),':',2)
I am just haveing a hard time understanding how I can get that value as a filter on my second table (Flights from OHR).
Re: Using filtered value across different dimensions
It looks like the solution might have something to do with using alternate states, adding a variable and possibly an action.
One of my coworkers mentioned he saw a demo which had a self refrencing hierarchy that had a similar requirement. In that situation there were two tables. One returned the employee attributes and the second returned employee attributes for anyone who that employee managed.