topic Re: SVG US County Map not working in QlikView

SVG US County Map not working

crystles — Wed, 21 Sep 2016 19:53:45 GMT

I have been working on creating US State maps with the county regions in them.

I found a site that has all of the states and the SVG for each here. (Georgia is selected since that is the map I am trying to create)

Georgia: free map, free blank map, free outline map, free base map : outline, counties (white)

I have the SVG file copied to here on my dev machine

C:\Users\user.name\AppData\Local\QlikTech\QlikView\Extensions\Objects\svgMap

I believe I have done everything I am supposed to do in order to get the map to work, but it is still not working and I don't understand why.

It will not even show me the map? The map box is just blank.

I have tried opening it in inkscape and saving it. I even tried going through the XML and changing the IDs for the polygons to the County names but that didn't work. I then tried having an excel document and having the original ID names from the map associated to the counties, but that didn't work either. I did not have a chance to change all of the IDs so some were blank... I don't know if that would have caused an issue or not? I really don't want to go through all the work of coding all 159 counties and it still not work.

Any help would be greatly appreciated! Thanks!

Re: SVG US County Map not working

MK9885 — Wed, 21 Sep 2016 20:11:58 GMT

Can you share the screenshot for the SVG Map Settings (Properties)?

Re: SVG US County Map not working

crystles — Wed, 21 Sep 2016 20:32:32 GMT

I did find that the borders showed up when I selected the "Element Border" box. Forgot to turn that on before. So it does have the counties outlined... but it isn't letting me click on any other them or using the pop up.

Re: SVG US County Map not working

Anonymous — Wed, 21 Sep 2016 20:39:28 GMT

Seems like Color Measure is not working..

Could you post Color measure you have?

Re: SVG US County Map not working

crystles — Wed, 21 Sep 2016 20:45:54 GMT

=If(Sum(MarketShare_ALL) > 10, '#439400', '#F2EF1B')

I'm pretty sure that is the correct syntax and all.

Re: SVG US County Map not working

Anonymous — Wed, 21 Sep 2016 21:25:47 GMT

Can you post a sample?

Check with Region ID: SVG_Code is mapped to your data in location!!

Re: SVG US County Map not working

MK9885 — Wed, 21 Sep 2016 22:25:44 GMT

I do not see a Map selected there 'Select or Load Map'

Select 'US Counties' in Map (See the image below)

Also make sure the Region ID is as per SVG acceptance ID.

EX: United States is US (Region ID) or Georgia is GA

If it still doesn't work then change the Georgia SVG file and download a new SVG file.

Thanks.

Re: SVG US County Map not working

Thu, 22 Sep 2016 04:32:12 GMT

Hi Crystal,

I believe you are doing all the correct steps. I was having the same issue and what it appears to be is the SVG itself.

Unless the SVG has a 'fill' attribute set it is not working.

Try the attached SVG and see if this works for you. It has the 'fill' attribute set and was downloaded from commons.wikimedia.org

Hope this helps!

- Stan

Re: SVG US County Map not working

Anil_Babu_Samineni — Thu, 22 Sep 2016 04:45:42 GMT

Does this expression seems in css

Can you please let me know the use of #

Instead of use that please use rgb

Re: SVG US County Map not working

crystles — Thu, 22 Sep 2016 13:39:20 GMT

I didn't have one of the listed maps selected because I had a downloaded map I was using, so that maps name was in the "Load SVG path".

Re: SVG US County Map not working

crystles — Thu, 22 Sep 2016 13:42:08 GMT

This map worked! Thank you so much!

I had tried one of the maps from the wiki site but they didn't seem to work.

Can you explain or show me where this "Fill" attribute is located? I will eventually have to create maps for all 50 states so I want to make sure I know how to fix it if I have problems with another map like this.

Thanks again for your solution and help!

Re: SVG US County Map not working

Fri, 23 Sep 2016 00:33:14 GMT

I made a mistake in telling you it was the 'Fill' attribute. I'm a little new at this. The svg files that you were using did not have an ID attribute on the 'path' tag.

So, as an example, here are the steps that would be needed to fix the Georgia svg file - the one you were using from the d-maps site that was not working:

Open the Georgia svg file using Notepad or Notepad++. You should find similar to the following:

Each of these paths is for a county in Georgia. Then add an ID to each path and give it a name, similar to the following.

Each id needs to match the values of the dimension that you are using in the svg Reader extension.

Then the svg should start working like below:

Naturally you would want to give better names than County1, etc. and this could be a lot of work with there being so many counties, but it illustrates how the svg files work.

I'm guessing there is a nice way to assign these ids in InkScape or any other tool, but not sure how this is done.

I hope this makes sense, but please let me know,

Stan