Mapping one value to multiple values in QlikView

[Anonymous]

Hi All,

I have a requirement wherein I need to map one region value to multiple region values. For instance, the value present in the data source is 'Global', and this needs to be mapped across multiple regions specifically, 'Americas', 'Asia-Pacific', 'Canada', 'Europe', 'Hong Kong', 'LATAM' and 'MENAT'. Attaching a screenshot of what the end result should look like. It should display a count for each of the regions mentioned above.

Could you please help with the same.

Regards,

Erwin Palani

[Anonymous]

I tried with applymap(), but it picks up the first value and doesn't map it against the other regions.

[tresesco]

You can use concatenated value in the mapping table instead of multiple values for the same source value and then use subfield like I showed above to create multiple rows against it.

[Anonymous]

Could you share an example for the same ? That would help a lot.

[vikraant]

I think the linking would work the best in this case.

[Anonymous]

Linking as in ? Could you share an example of it ?

[PolBe]

did you find the solution for your issue in the end?