set selection

[#1]

Hi,

I am using set analysis for some calculations.

I am trying to get qlikview to select a set of dates when the user selects identicial dates in another field. how do I write this expression?

Thanks

Just to clarify, I have the following tables:

TABLE_A:

Name	Cost	Location
John	3245	POL
Ben	345345	POL
Dave	4	UK
mary	35353532	POL
jim	342	UK
Jam	345	UK

TABLE_B:

Location_external
UK
POL
USA

When I select (for example) "POL" in TABLE_B, I need TABLE_A to be filtered to all records  with POL in the location field.

At the moment Location and Location_external are not linked in anyway.

How can I do this using set analysis?

Thanks

[DavidFoster1]

You are going to need to explain this more fully.

[#3]

Just added some detail hope thats helpful.

[#4]

give details

[#5]

Just updated the original message. is that helpful?

[Gysbert_Wassenaar]

Rename Location_External to Location so QV can associate the fields. Then add a listbox for the Location field and select the value POL. That's the easy way.

If you want to do things in an unnessarily complicated way the you can add a listbox for Location_External and add a Select in Field action to the OnSelect field trigger (on the Triggers tab of the document properties window). The field to select in is Location and the search string is: '(' & concat(distinct chr(34) & Location_External & chr(34), '|') & ')'

[#7 · Accepted solution]

Figured it out,  but thanks for the help