Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Luffy20
Contributor III
Contributor III

Map chart

Hi all,

 

Country Vehicles
Austria 77
UK 99
Canada 65
France 3
Germany 22
Italy 11
Japan 55
india 22

 

I have the above data and i need to show european countries and other countries separately in map

if(Match(Country,'Austria','UK','france','Germany','Italy'),Europe,

if(Match(Country,'japan','India'),Other)) as Country_new

I had wrote this in load editor and made country_new field,but this field is not supporting in map chart,can you help me with this

Thanks

Labels (5)
2 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

I think using Qlik GeoOperation could help you. More specifically, this function:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Global_Common/GeoOperationsFunctio...

vikasmahajan
MVP
MVP

Hi Luffy,

Create this transformation while loading your script 

if(Match(Country,'japan','India'),Other)) as Country_new

In map just refer Country_new field.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.