Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

country maping

Hi all,

omar bensalem

i want to map the country values to limited. how can achieve this?

i have  region and country

region:

Americas 

AsiaPacific

EMEA

in country i have so many but my requirment is   i want to show in country list   if i select  EMEA ,Americas,AsiaPacific , only below criteria should come.

In americas - UnitedStates,Canada ,OtherAMS

in AsiaPacific-  India,China, OtherAPJ

in EMEA - Germany,UnitecdKingdom ,OtherEMEA

1 Solution

Accepted Solutions
avinashelite

Create an new Country field like this


IF(Region='Asia Pacific' and (Country='India' or Country='China' ),Country,

if(Region='Asia Pacific' and (Country<>'India' or Country<>'China' ),'OtherAPJ',

if(Region='Americas' and (Country='United States' or Country='Canada' ),Country,

if(Region='Americas' and (Country<>'United States' or Country<>'Canada' ),'OtherAMS',

if(Region='EMEA' and (Country='Germany' or Country='United Kingdom' ),Country,

if(Region='EMEA' and (Country<>'Germany' or Country<>'United Kingdom' ),'OtherEMEA',Country

))

)))) as Country_NEW,

View solution in original post

18 Replies
YoussefBelloum
Champion
Champion

Hi,

you can try to use a where clause on the Country field, like this

table:

load

.

.

FROM

WHERE Match(Country,'UnitedStates','Canada ','OtherAMS','India','China','OtherAPJ','Germany','UnitecdKingdom ','OtherEMEA');

soniasweety
Master
Master
Author

Not working sir.

youssef belloum

in country listbox   rest of the country's is not showing like


OtherAMS

OtherAPJ

OtherEMEA  match.PNG

soniasweety
Master
Master
Author

Hi Avinash R

Tresesco B  any idea on this?

Frank_Hartmann
Master II
Master II

Maybe like attached

hope this helps

soniasweety
Master
Master
Author

is there any other way in scripting   

i dont want to use caluclated dimension    we need to use direct dimension itself

soniasweety
Master
Master
Author

cant we achieve throguh this where clause?

FROM

WHERE Match(Country,'UnitedStates','Canada ','OtherAMS','India','China','OtherAPJ','Germany','UnitecdKingdom ','OtherEMEA');

avinashelite

Create an new Country field like this


IF(Region='Asia Pacific' and (Country='India' or Country='China' ),Country,

if(Region='Asia Pacific' and (Country<>'India' or Country<>'China' ),'OtherAPJ',

if(Region='Americas' and (Country='United States' or Country='Canada' ),Country,

if(Region='Americas' and (Country<>'United States' or Country<>'Canada' ),'OtherAMS',

if(Region='EMEA' and (Country='Germany' or Country='United Kingdom' ),Country,

if(Region='EMEA' and (Country<>'Germany' or Country<>'United Kingdom' ),'OtherEMEA',Country

))

)))) as Country_NEW,

YoussefBelloum
Champion
Champion

so you want to limit Country values only on selections ?

soniasweety
Master
Master
Author

i want to use country in pivot table when user select region  the respected country values should show in pivot table.