Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

joshpala
New Contributor II

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

14 Replies
MVP
MVP

Re: Mapping one value to multiple values in QlikView

Could you post a small sample of your source data in tabular format against this expected output?

vikraant
Contributor

Re: Mapping one value to multiple values in QlikView

Hi Joshua ,

You could link your main table using Region as the key

Load * Inline [

%Region   , Sub-Region

Global , Americas

Global , Asia-Pacific

Global , Canada

Global , Europe

Global, Hong Kong

Global , LATAM

Global , MENAT

];

Please provide with sample data for more clarity.

Best Regards,

Vikraant

joshpala
New Contributor II

Re: Mapping one value to multiple values in QlikView

Hi, thank you for the response. Please find attached the sample data.

joshpala
New Contributor II

Re: Mapping one value to multiple values in QlikView

Hi, thank you for your response. Please find attached the sample data.

MVP
MVP

Re: Mapping one value to multiple values in QlikView

Is your real data source an excel and that too wrapped celled, like in attached sample?

joshpala
New Contributor II

Re: Mapping one value to multiple values in QlikView

Yes

MVP
MVP

Re: Mapping one value to multiple values in QlikView

Try like:

LOAD [Ticket Number],

          Services,

          Location,

          SubField(Region, chr(10)) as Region

FROM <>;

joshpala
New Contributor II

Re: Mapping one value to multiple values in QlikView

Hi Tresesco, sorry for the misunderstanding. The location field is present in the data source extracted and it needs to be mapped to the region field. The ' Region ' field is the output expected by using the location field.

MVP
MVP

Re: Mapping one value to multiple values in QlikView

Not sure I understand. Try using applymap().

Community Browser