Something like this:
MAPSEGMENTS:
Mapping LOAD Segment, SalesRepID
FROM ....;
Data:
LOAD Segment,
SalesRepID,
RouteSegment,
MapSubString('MAPSEGMENTS', RouteSegment) as RouteSales
FROM ....;
PS: posted in wrong forum. Should be posted to a Qlikview or QikSense forum, not the community forum.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein