Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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