topic Re: Re: Map issues-google map api didn't show in QlikView

Map issues-google map api didn't show

Tue, 25 Nov 2014 02:31:16 GMT

hello

We want to show customer sales by location in QlikView which needs to use map,but we cannot use Google map api ,what should we do?

(we are using QlikView in China,you know~)

thx

Re: Map issues-google map api didn't show

JonnyPoole — Tue, 25 Nov 2014 03:24:37 GMT

How do you want the map to work ? Bubbles on a map ? Polygon heat map ?

You may want to try extensions which would be free to use (and/or develop) . A common one is below. There are others.

brianwmunz/svgReader-QV11 · GitHub

GeoQlik and Analytics8 have strong licensed solution for doing sophisticated mapping as well.

Re: Map issues-google map api didn't show

Tue, 25 Nov 2014 10:51:07 GMT

thank you fro your reply.

But we still have problems with the 'color expression' part.

We want to make the part red when its sales<4000,show green else,how to create the expression?

thank you again~ (*^__^*)

Re: Map issues-google map api didn't show

JonnyPoole — Tue, 25 Nov 2014 15:00:56 GMT

Are you referring to the SVQ Reader extension referenced above ?

If you are , there is a 'color expression' listed in the extension properties below . i'm not 100% positive, but i BELIEVE you can write a conditional color expression using qlik functions if( sum(Sales) > 4000, <green color expression> , <red color expression> )

Re: Map issues-google map api didn't show

Wed, 26 Nov 2014 02:28:34 GMT

THX AGAIN~

we've tried,but it always show the white blank~

Re: Map issues-google map api didn't show

JonnyPoole — Wed, 26 Nov 2014 17:32:45 GMT

Hi - you are definitely on the right track, but when i set this up myself i had some difficulty making sure that the values in my 'Region ID' field matched up with whats in the SVG map .

To make sure your values will work,i recommend you install the following SVG editor (it is also referenced in the github post by the extension author)

http://www.inkscape.org/en/

Once you install it you can open the SVG file , select 'edit paths by nodes' on the left (as you see below),

right click on an individual region and see the exact ID value. In this case its CN-15.

In QlikView, you are using the 'pro' field from your qlik data model... does it have 'CN-15' (and other values that match the SVG region IDs) as a value ?

Also , try using red() or green() or another qlikview function like rgb() to define the color in the 'color extension property.

Re: Re: Map issues-google map api didn't show

JonnyPoole — Thu, 27 Nov 2014 03:48:37 GMT

Here is an example

Re: Map issues-google map api didn't show

Thu, 27 Nov 2014 05:40:26 GMT

thank you

I am sure that my regionID is correct,because the value has been put on the picture.

I wonder that why my color expression didn't work.

%>_<%

Re: Map issues-google map api didn't show

JonnyPoole — Thu, 27 Nov 2014 16:30:40 GMT

I think your expression is syntactically correct

Can you create a bar chart with the 'Pro' field as the dimension and sum(Sales) as the expression ? i would like to see what is formed.

Also if you can do a screenshot of your data model showing which table 'Pro' is in and which table 'Sales' is in that would help too....

Re: Map issues-google map api didn't show

Mon, 01 Dec 2014 06:21:55 GMT

thank you so much for your reply

but can you show me the xlsx (data source)?

here is my screenshot

Re: Map issues-google map api didn't show

Mon, 01 Dec 2014 06:35:10 GMT

AND when I change the color expression,it always shows

Re: Re: Map issues-google map api didn't show

JonnyPoole — Mon, 01 Dec 2014 14:14:07 GMT

Here is the data attached.

What browser and version are you using ? The QlikView Desktop webview leverages a browser to render.

At this point I'm sensing there maybe something in you the browser version , proxy or web connection that is causing the error .

Re: Map issues-google map api didn't show

Wed, 03 Dec 2014 05:23:15 GMT

Thank you so much.

My browser is IE8.

Maybe it's the reason.

Re: Map issues-google map api didn't show

JonnyPoole — Wed, 03 Dec 2014 13:32:45 GMT

It probably is. Are you testing just on QV Desktop or do you have a QV Server to test against ? I would suggest upgrading IE or, if you have a server, install firefox or chrome and test the extension through the AJAX/Web interface of the server.

You are very close so i'm hoping you have some browser flexibility !

Re: Map issues-google map api didn't show

Wed, 17 Dec 2014 02:25:45 GMT

problem solved.

I download another version of svg map,and it worked.

http://market.qlik.com/qlikview-svg-map.html