country maping

[soniasweety]

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

[avinashelite]

check the attachment

[OmarBenSalem]

in ur load, try as follow:

if(Region='Americas', if(Country<>'UnitedStates' or Country<>'Canada', 'OtherAMS','Country),

if(Region='AsiaPacific', if(Country<>'India' or Country<>'China', 'OtherAPJ','Country),

if(Region='EMEA ', if(Country<>'Germany' or Country<>'UnitecdKingdom ', 'OtherEMEA','Country) )) as NewCountry

then use this new dimension

[soniasweety]

syntax error it is showing

[OmarBenSalem]

Just add anoter ) in the end

[soniasweety]

No sir still same error

[vikasmahajan]

Instead of multiple if it is recommended that  you can use apply map command in Qlikview. Refer attached demo.

HTH

Vikas

[OmarBenSalem]

My bad !

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

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

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

Result:

[Frank_Hartmann]

see attached.

hope this helps

[soniasweety]

Nice approach.  Thanks