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

[tresesco]

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

[vikraant]

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

[Anonymous]

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

[Anonymous]

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

[tresesco]

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

[Anonymous]

Yes

[tresesco]

Try like:

LOAD [Ticket Number],

          Services,

          Location,

          SubField(Region, chr(10)) as Region

FROM <>;

[Anonymous]

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.

[tresesco]

Not sure I understand. Try using applymap().