Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
Master
Master
Author

Hi Sunny Talwar ( any help on this?

sunny_talwar

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

soniasweety
Master
Master
Author

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
Master
Master
Author

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

sunny_talwar

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
Master
Master
Author

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?

sunny_talwar

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);

soniasweety
Master
Master
Author

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?

sunny_talwar

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