Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello masters,
Want to see if I could replicate a State to City level drill down with my current Qlik mapping fictions.
something like this ( This is a country to city)
The demo link https://sense-demo.qlik.com/sso/sense/app/eed1c69b-3675-41f8-a852-4f71de096e50/sheet/pRbH/state/anal...
Quick snapshot
My Qlik account has a Map chart with these 6 layers...My data contains zip code, city name and county. If I need to have an additional extension to build that State to City drill down?
Thanks
If you create a Drill down dimension master item with State>City.
Then create an area layer for State and a point layer for City, as you make selections in your drill down dimension the map will focus on what you select. Also in the Options for each layer you can also modify the Show in zoom levels under Layer display to restrict what you see based on the zoom level.
Agree with Lisa here, City is not a great method to drill into as the geometry may not be in there to drill into.
I was able to create a drill down from State>Zip>IDN. I did this with two layers. First being an area layer with the drill as dimension, left auto on location, and placed 'US' in the Country. Then created a point layer with drill down as dimension and used a lat and long field created from your GeoPoint field as I had issues with geopoint mapping. This was created as follows: SubField(Geopoint,',',1)as Lat, SubField(Geopoint,',',2)as Long.
In layer display on the point layer I turned off visible in the upper layers:
I then colored the area layers by sum of Dollar units in order to "heat map" the locations.
Hope this helps to point in the right direction, I know you were hoping to get cities but just don't think its the move here.
If you create a Drill down dimension master item with State>City.
Then create an area layer for State and a point layer for City, as you make selections in your drill down dimension the map will focus on what you select. Also in the Options for each layer you can also modify the Show in zoom levels under Layer display to restrict what you see based on the zoom level.
Hi Lisa,
I am now stuck with the very first step of making an area layer for USA.
see the second screen shot of error message. Is that because of incorrect template of my State field?
What is APCL?
And only I change the location type into Admin area (level 1), it goes to USA.
Why not 'Country' does not work?
Please advise
This is due to using the state abbreviations.
Administrative area (Level 1): First-level administrative area names. such as a state or province names.
Change the Location type to Admin level 1.
Sharing a bit of your data would also be helpful here so we can help show you the drill down.
Hi Steven,
I attached my file here. It has state, city and even Geopoint I just mapped.
would you please take a look to see why I just can't get the drill-down (State to City) ?
This should be your settings for State:
Not all your cities were detected, so ZIP might be a better option to show each location.
Create a drill down dimension State, IDN and when you represent IDN as a point layer, use ZIP as location, Location type as Postal code/ZIP code and Country 'US' as above.
Agree with Lisa here, City is not a great method to drill into as the geometry may not be in there to drill into.
I was able to create a drill down from State>Zip>IDN. I did this with two layers. First being an area layer with the drill as dimension, left auto on location, and placed 'US' in the Country. Then created a point layer with drill down as dimension and used a lat and long field created from your GeoPoint field as I had issues with geopoint mapping. This was created as follows: SubField(Geopoint,',',1)as Lat, SubField(Geopoint,',',2)as Long.
In layer display on the point layer I turned off visible in the upper layers:
I then colored the area layers by sum of Dollar units in order to "heat map" the locations.
Hope this helps to point in the right direction, I know you were hoping to get cities but just don't think its the move here.
Hi Steven,
Thanks again for your advise. yeah... It works ....
Just another followup question. is that way to show the full number? here only shows 2..... , it actually is 2.8K or 2800.
It is a simple area layer with State as location. I customized the color by expression of =aggr(SUM([Pack Units]),[State])
The area layer only show portion of number not all of them...anyway to adjust into full number display?
Great to hear! For the label you can try the following: In the area layer, go down to tooltip. Turn on Custom and put your formula in the measure. Turn off auto format and show as number.
Hi Steven,
Maybe I missed somewhere....do not find a format option at color section under area layer ....there is a one of label at General setting where I tried to put my formula ....but still does not work...
would you mind showing me a screen shot or something?