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: 
bhoomika_101
Contributor II
Contributor II

Map Chart

I have city of US only but 2 cities are indicting in Africa and south America. How to remove city from other country and place in US?map.PNG  

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

if you have a field in your dataset that specifies the region then you can filter specific values using SET ANALYSIS

example

sum( {< Region={"NORTHAMERICA"} > }payment_amount)

OR

Exclude values, below will exclude country1 and country2 from calculation

sum( {< COUNTRY -={'Country1','Country2'} > }payment_amount)

 

refer below for more on SET ANALYSIS

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/https://www.analyticsvidhya.com/b...

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
bhoomika_101
Contributor II
Contributor II
Author

bhoomika_101_0-1675355344205.png

 

I don't have such kind of country or region