topic set selection in QlikView

set selection

Wed, 04 Sep 2013 16:42:39 GMT

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

Re: set selection

DavidFoster1 — Wed, 04 Sep 2013 16:45:40 GMT

You are going to need to explain this more fully.

Re: set selection

Wed, 04 Sep 2013 17:03:56 GMT

Just added some detail hope thats helpful.

Re: set selection

Wed, 04 Sep 2013 17:06:33 GMT

give details

Re: set selection

Wed, 04 Sep 2013 17:12:19 GMT

Just updated the original message. is that helpful?

Re: set selection

Gysbert_Wassenaar — Wed, 04 Sep 2013 17:51:31 GMT

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), '|') & ')'

Re: set selection

Thu, 05 Sep 2013 13:24:02 GMT

Figured it out, but thanks for the help