Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vaibhavsathe
Contributor
Contributor

USA Territories with QlikSense GeoAnalytics

Hi

I am trying to create a bubble chart and if I use Location- Option -> Country - USA then I am not seeing US territories and if I select Any then it shows entire world. How I can limit this so I will able to get All US States as well as US Territories only

4 Replies
isingh30
Specialist
Specialist

Try this in expression.

= only({<Country = {'US'}>}State & Territory)

Thanks.

bluecarbon
Partner
Partner

Should we create two fields separately for state and territory? When I have PR, GU, VI in state field Qlik map is not recognizing or plotting it.

Thank you, 

Rakul

Patric_Nordstrom
Employee
Employee

GU,PR and VI (since they have iso codes) are kept on country level in the location database and not under US as states.

Try an area layer with  =valuelist('GU','PR','VI') to locate them.

Thanks,

Patric

 

bluecarbon
Partner
Partner

Thank you Patric.