Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

bmz
Valued Contributor

New Geospatial Mapping Extensions using Google Maps

FYI, I've just posted an extension which uses OpenLayers and OpenStreetMap (both of which are free) to do this kindof mapping:

http://community.qlik.com/message/181821#181821

It loads in KML files, allowing for custom (or any other kind of) regions.

Not applicable

Re: New Geospatial Mapping Extensions using Google Maps

Hey Brian,

this is amazing..

I have a report with State List Box. and I am trying to add USA Map ..

Is there any instruction on how to do add the map there and how can I connect it to the state Field that I have.

Thanks

Not applicable

New Geospatial Mapping Extensions using Google Maps

Hi Bryan,

I tried to use your US Map extension for getting different shades of color density for my Net Sales % expression according to States. Seems the extension works easily for simple and direct calculations. As the Net Sales % expression is little complex, I cannot see the data even showing up for this expression.

=The Net Sales % expression used is:

SUM({$<[Year-Quarter] = {$(=ONLY([Year-Quarter])) }>}Sales) / SUM({$<[Year-Quarter] = {$(=ONLY([Year-Quarter])) }>} Total Sales)

Let me know how I can proceed ahead.

Not applicable

New Geospatial Mapping Extensions using Google Maps

Hi,

  We are using this extension in our application. But for one user, the extension 'Sorry. No imagery Here'. He gets a popup blocker when he accesses the app. any browser settings we need to take care of?

Not applicable

Re: New Geospatial Mapping Extensions using Google Maps

Hi Brian, very interesting Topic indeed but there are many technical limitations using Google Maps (GMaps) to display QlikView KPI indicators. Indeed, you cannot display several indicators at the same time and on the same map (background + foreground indicators), you are also limited to bubbles and therefore cannot display pie/bar charts nor "real" heat maps. On top of that, you cannot display QlikView KPIs on specific Sales/Business Areas with GMaps such as the Bricks in the Pharmaceutical sector (Brick = aggregation of zipcodes).

Moreover, there are also a few "commercial" aspects to be considered since many QlikView customers & channel partners use GMaps API "FREE" Key inside their QlikView server or rich client without complying with GMaps license terms...Indeed, for "professional internal use" (intranet, extranet or internet with username/password authentication to QlikView application), you must buy GMaps API "Premier" which costs about 10,000 $ USD per year or 8,500 euros per year + possible extra fees depending upon the total number of daily hits.

A few alternatives exist such as Open Street Map (totally FREE) or other WMS/TMS services. I suggest you to have a look at our new mapping extension for QlikView 11 SR1 namely "GeoQlik v11.6":

http://www.geoqlik.com/en/geoqlik-for-qlikview/geoqlik-v11.html

Please find hereafter a few screenshots of GeoQlik V11.6 using WMS/TMS services to display QlikView KPIs:

geoqlik_v11_demo_1.JPGgeoqlik_v11_demo_2.JPGgeoqlik_v11_demo_3.JPGgeoqlik_v11_full.jpg

Highlighted
Not applicable

Re: New Geospatial Mapping Extensions using Google Maps

Hey,

Thanks for creating such a helpful Map Extension for Qlikview.

Actually I was trying to use the Extension with my data. But I am not able to see the colors in the US Map.

I took the same app and uploaded my data having no change in settings except the field in Expression.

I am now unable to troubleshoot the issue. Everything seems to be fine, but colors are not coming in the chart.

But in your application it is working perfectly fine.

I would appreciate suggestions from you.

Regards,

Neelam

bmz
Valued Contributor

Re: New Geospatial Mapping Extensions using Google Maps

Could you please post your expression?

Thanks.

Not applicable

Re: New Geospatial Mapping Extensions using Google Maps

MExican Maps ??? You can send your excel tab??? thanks

Cheers

Not applicable

Re: New Geospatial Mapping Extensions using Google Maps

Ok, silly question. I have a data set (Excel) that consists of election results:

  • Election Type
  • State
  • Position/Seat
  • Candidate Name
  • Candidate Party
  • Candidate Vote Percent
  • Notes

How can I use this extension to allow uses to click on a state and see the election results for that state?

Thanks!

bmz
Valued Contributor

Re: New Geospatial Mapping Extensions using Google Maps

In a pop up or something like that?  Or to see all of the data on the sheet change to reflect that click?    

Community Browser