topic Re: Mapping one value to multiple values in QlikView in QlikView

Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 07:02:01 GMT

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

Re: Mapping one value to multiple values in QlikView

tresB — Mon, 12 Feb 2018 07:07:37 GMT

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

Re: Mapping one value to multiple values in QlikView

vikraant — Mon, 12 Feb 2018 07:21:11 GMT

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

Re: Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 07:33:16 GMT

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

Re: Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 07:35:25 GMT

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

Re: Mapping one value to multiple values in QlikView

tresB — Mon, 12 Feb 2018 07:38:27 GMT

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

Re: Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 09:09:16 GMT

Yes

Re: Mapping one value to multiple values in QlikView

tresB — Mon, 12 Feb 2018 09:20:05 GMT

Try like:

LOAD [Ticket Number],

Services,

Location,

SubField(Region, chr(10)) as Region

FROM <>;

Re: Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 09:25:21 GMT

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.

Re: Mapping one value to multiple values in QlikView

tresB — Mon, 12 Feb 2018 09:36:40 GMT

Not sure I understand. Try using applymap().

Re: Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 09:47:03 GMT

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

Re: Mapping one value to multiple values in QlikView

tresB — Mon, 12 Feb 2018 09:52:40 GMT

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.

Re: Mapping one value to multiple values in QlikView

Anonymous — Mon, 12 Feb 2018 11:15:34 GMT

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

Re: Mapping one value to multiple values in QlikView

vikraant — Mon, 12 Feb 2018 12:55:35 GMT

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

Re: Mapping one value to multiple values in QlikView

Anonymous — Wed, 21 Feb 2018 10:16:05 GMT

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

Re: Mapping one value to multiple values in QlikView

PolBe — Tue, 26 May 2020 11:00:52 GMT

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