Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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
check the attachment
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
syntax error it is showing
Just add anoter ) in the end
No sir still same error
Instead of multiple if it is recommended that you can use apply map command in Qlikview. Refer attached demo.
HTH
Vikas
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:
see attached.
hope this helps
Nice approach. Thanks