Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

Re: Mapping country

yes sunny,

both BB and Mi both are diff tables and am concatenating both this tables.

for UI  one dashboard I need to show both count

and one dashboard for each individual counts.

for that I crated flag.

Re: Mapping country

Then if you are using ApplyMap in both the tables, then all you need is this

Dimension

Region

Expression

Count(Region)

soniasweety
Contributor III

Re: Mapping country

Sunny,

is it correct am doing?

MappingTable:
Mapping
LOAD Code,
Destination
FROM

(
ooxml, embedded labels, table is CountryCodes);

MI:
LOAD Co,
ApplyMap('MappingTable', Co, 'N/A') as Region
FROM

(
ooxml, embedded labels, table is MI);
concatenate
BB:
LOAD Country,

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

(
ooxml, embedded labels, table is BB);

here am adding one more table  and doing applymap is it correct or anything need to do?

Re: Mapping country

May be do it like this

MappingTable:
Mapping
LOAD Code,
Destination
FROM

(ooxml, embedded labels, table is CountryCodes);

Table:
LOAD Co as Country,
ApplyMap('MappingTable', Co, 'N/A') as Region
FROM

(ooxml, embedded labels, table is MI);


Concatenate (Table)
LOAD Country,

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

(ooxml, embedded labels, table is BB);

soniasweety
Contributor III

Re: Mapping country

yeah sunny its working thank you. I will close this thread once I test with my original app.

Small doubt. : in each my table I have 20 columns is there  is it effect anything?

will I load each table along with above code is fine?

Re: Mapping country

It should be fine just make sure that matching columns between the two tables are named with the same name just like I did for Co as Country

soniasweety
Contributor III

Re: Mapping country

Okay sunny,

Thanks for the right suggestions towards the accurate output

Highlighted
soniasweety
Contributor III

Re: Mapping country

hiSunny Talwar

I believe its working as expected but

my question is like  I have separate dahboards to display individual counts

if I use above code  I will get only  one column with region it will give the totl count of BB and MI

so can I use like this?

Table:
LOAD Co ,

Co as Country,

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

Re: Mapping country

You mentioned you created flags? May be add Flag as your dimension?

soniasweety
Contributor III

Re: Mapping country

yes sunny,

I tried like above its working but is it cause any performance issue?

Community Browser