Mapping a value in to multiple dimensions

[MHarrell]

Hi All,

I need to create a map that will allow a county to fall in to multiple service areas.  My current map only returns the service area where the county was first loaded.  In the example below Hardin County is part of Louisville and LaGrange's secondary service area (SSA) but it's also part of the primary service area (PSA) for Hardin.  Here's an example below.  What's the correct way to build this so that Hardin county will show up whether I filter on the Louisville and LaGrange SSA or Hardin PSA?

ServiceAreaMap:
Mapping LOAD * INLINE

[county_name, ServiceArea

Nelson - KY , Louisville and LaGrange SSA
Hardin - KY , Louisville and LaGrange SSA
Hardin - KY , Hardin PSA];

Thanks for your help!

Matt

[rwunderlich · Accepted solution]

A mapping table will only return one result, whereas a standard table can have a one-to-many relationship.  In your case, remove the "Mapping" prefix and let the table remain in your model as a standard table.  Then Hardin will be associated with both service areas.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[MHarrell]

Thanks for your help!