Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mapping one value to multiple values in QlikView

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

15 Replies
Anonymous
Not applicable
Author

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

tresesco
MVP
MVP

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
Not applicable
Author

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

vikraant
Creator
Creator

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

Anonymous
Not applicable
Author

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

PolBe
Contributor III
Contributor III

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