Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 - Creator
Partner - Creator

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 - Creator
Partner - Creator

Thank you Patric.