Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

Mapping country

Hi all,

Gysbert Wassenaar

Antonio Mancini

I have 3 separate tables .

MD

MI

country codes

so  I need to create one column with region like below,how can I achieve  its like   for one chart I need to show region wise count. nd one chart for separate tables .  [in each table I have several columns but I have given only one column for time being in attached excel]

   

Region
EMEA
Banglor
United States of America
Melbourne
singapore
Budapa
20 Replies
soniasweety
Contributor III

Re: Mapping country

Hi Sunny Talwar ( any help on this?

Re: Mapping country

You want to map to Region from Country? Is that the goal?

soniasweety
Contributor III

Re: Mapping country

yes sunny,

first two sheets code_BB   Code_MI     3rd sheet  we need to map  witht that code and corresponding country and destination

based on that I need one calumn like region which I shown above.

soniasweety
Contributor III

Re: Mapping country

simple example is

code_BB   sheet map with countrycode sheet and create one region

Code_Mi     sheet map with countrycode sheet and create one region 

in final I need count(region) for both

Re: Mapping country

So you need to do something like this

MappingTable:

Mapping

LOAD Country,

     Region

FROM ....;

FactTable:

LOAD Country,

     ApplyMap('MappingTable', Country, 'N/A') as Region,

     ....

FROM ....;

soniasweety
Contributor III

Re: Mapping country

thank you  sunny,

but I am unable to get the desired output  can u attach small sample with 10 or 15 records?  by that I can map with my data?

Re: Mapping country

Something like this

MappingTable:

Mapping

LOAD Code,

    Destination

FROM

[..\..\Downloads\codes.xlsx]

(ooxml, embedded labels, table is CountryCodes);

Fact:

LOAD Co,

ApplyMap('MappingTable', Co, 'N/A') as Region

FROM

[..\..\Downloads\codes.xlsx]

(ooxml, embedded labels, table is MI);

Highlighted
soniasweety
Contributor III

Re: Mapping country

Thanks sunny,

I don't have qlikview license but I got the region column. But  here I my requirement is,

I need to show pie chart  count(region) of both BB&MI   how can I write both mapping tables in one?

Re: Mapping country

Are these both in two different tables? Do you concatenate these two tables into one? Not sure how your data model looks like?

Community Browser