topic Re: Uding filtered value across different dimensions in QlikView

Using filtered value across different dimensions

datagrrl — Mon, 21 Jul 2014 14:52:59 GMT

Good Morning-

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).

Any suggestions or help is appreciated.

Message was edited by: Randi Borys Mispell

Re: Uding filtered value across different dimensions

Anonymous — Mon, 21 Jul 2014 14:56:28 GMT

Have you tried having 2 independent List boxes ?

One for DestAiport
The other for OriginAirport

Re: Uding filtered value across different dimensions

datagrrl — Mon, 21 Jul 2014 14:59:25 GMT

By this do you mean somehow hiding the second one?

That might work. I didn't think of this.

The requirement is pretty much as I outlined above, so I need to end up with one list box visible to the user.

Re: Uding filtered value across different dimensions

Anonymous — Mon, 21 Jul 2014 15:05:04 GMT

That is not what I meant, I suspect I misunderstand what you are trying to achieve.

Do you have a single table and within that do you want to be able to select rows where :

Either

DestAiport = selected airport

OriginAirport = same select airport

Re: Using filtered value across different dimensions

datagrrl — Mon, 21 Jul 2014 15:14:42 GMT

That is an option, but the formatting to the requirement is probably going to be harder.

So yes, I have a single Fact Table. The value that I am filtering on is the actually ID in the fact table, DestAirportID.

I also want to see, in a separate table if possible all of the routes where this DestAirportID is the OriginAirportID.

Re: Using filtered value across different dimensions

datagrrl — Mon, 21 Jul 2014 18:36:04 GMT

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.

Maybe that will help in telling me where to look.

Re: Using filtered value across different dimensions

datagrrl — Mon, 21 Jul 2014 18:51:23 GMT

Okay, I found the answer in some suggestions in this post.

http://community.qlik.com/ideas/2340