topic Re: Short Review of Geographic Mapping Options in QlikView in QlikView

Short Review of Geographic Mapping Options in QlikView

Josh_Good — Mon, 06 May 2013 22:51:37 GMT

A short review of some of the various mapping options in QlikView.

Link to instructions on using a scatter plot to map:http://community.qlik.com/docs/DOC-3136

Link to Qlik Map Extension: http://market.qlik.com/qlikview-qlik-map.html

Link to SVG Map Extension: https://github.com/brianwmunz/svgReader-QV11

Link to QlikMarket: http://market.qlik.com/

***Update

I have also uploaded a zip file that has QVDs with the latitude and longitude for everyzip code in the world.

Source for the data is here: Postal Codes

http://youtu.be/Cw9lwkBYNro

Re: Short Review of Geographic Mapping Options in QlikView

Thu, 05 Sep 2013 15:48:14 GMT

Thanks for this information. I just discovered GeoNames and have been working with it. Maybe you might be able to help me with what I'm trying to do.

Ref:
Anyone imported GeoNames data into Qlikview?

Thanks,

Re: Short Review of Geographic Mapping Options in QlikView

manojkulkarni — Tue, 04 Mar 2014 04:34:57 GMT

What are the coordinates used in the application ? is it combination of latitude & longitude ? what is the format ?

Re: Short Review of Geographic Mapping Options in QlikView

Josh_Good — Tue, 04 Mar 2014 14:23:11 GMT

This video discusses many mapping options each witgh a different way to address locating the data correctly on the map. In general, lat and long are used except for with heat maps. The specific format is different with each solution. I recpmmend you review the documentation and/or examples included with the solution you would like to use.

Re: Short Review of Geographic Mapping Options in QlikView

manojkulkarni — Wed, 05 Mar 2014 06:03:44 GMT

I would like to use Qlik Map example.Please could you provide if any documentation available with you. I am not getting any document related to Qlik Map.

For Qlik map example from the video, you have created coordinates for second dimension. Pls could let me know what is the format or how the coordinate data looks like ?

Re: Short Review of Geographic Mapping Options in QlikView

mrbowlesdwf — Wed, 05 Mar 2014 11:26:11 GMT

Have Qlik Map and SVG extensions been taken down from QlikMarket? I can't seem to find them via your links.

Re: Short Review of Geographic Mapping Options in QlikView

mrbowlesdwf — Wed, 05 Mar 2014 12:55:32 GMT

Think I've answered my own question. The links have changed following the Qlik rebrand:

Link to Qlik Map Extension: http://market.qlik.com/qlikview-qlik-map.html

Link to SVG Map Extension: http://market.qlik.com/qlikview-svg-map.html

Link to QlikMarket: http://market.qlik.com/

Re: Short Review of Geographic Mapping Options in QlikView

manojkulkarni — Tue, 11 Mar 2014 05:18:31 GMT

Hi Josh Good,

It was very nice demonstration on Qlik Map extension. I would like to know your suggestion for my requirement.

Client requirement is :

1. Analysis of Sales on Country Map (India).

2. Server doesn't have internet access to use google API for country maps.(google maps)

3. The map should be able to provide drilldown option.

4. Does Qlikmap extension requires internet ? How is the map getting displayed.

Do send me if you any document on QlikMap samples.

Re: Short Review of Geographic Mapping Options in QlikView

Josh_Good — Tue, 11 Mar 2014 15:33:18 GMT

Yes the free QlikMap extension requires internet access. Attached is an example app that comes with the extension. It would be possible to download all the mapping tiles and then adjust the extension to look a local images vs using an online map. This is beyond my expertise, if you want to go this way and need help please start a new discussion.

You other option would be the SVG extension. You can setup the SVG image to change based on the selections to give drill down. Attached is an example using the population of North America

Re: Short Review of Geographic Mapping Options in QlikView

Anonymous — Tue, 15 Jul 2014 00:48:04 GMT

I downloaded the extension but it is in zip and not qar farmat. I renamed it to .qar and double click on it and got an error

"In total 0 files in 1 directories were installed"

Can you advice how to install the extension ?

Re: Short Review of Geographic Mapping Options in QlikView

Josh_Good — Tue, 15 Jul 2014 04:19:25 GMT

Try openning the zip. Inside the zip there should be a .qar and other files such as an example qvw.

Re: Short Review of Geographic Mapping Options in QlikView

Anonymous — Tue, 15 Jul 2014 04:43:25 GMT

Josh,

There is no .qar file in the zip file.

Re: Short Review of Geographic Mapping Options in QlikView

Josh_Good — Tue, 15 Jul 2014 20:22:55 GMT

Thanks for the image. The files from the image are what I would expect to see in a .qar file (when it is unzipped). Change the extension to .qar and try again. Then check if the extension has been installed.

Re: Short Review of Geographic Mapping Options in QlikView

Anonymous — Wed, 16 Jul 2014 15:41:06 GMT

That was what I did and I mention in my original post in Jul 14 that I get a message saying 0 files were installed.

Re: Short Review of Geographic Mapping Options in QlikView

Anonymous — Wed, 16 Jul 2014 15:43:54 GMT

I just tried renaming .zip to .qar and managed to install it ! I am not sure why it failed the last time.

Thanks

Re: Short Review of Geographic Mapping Options in QlikView

Fri, 01 Aug 2014 21:43:30 GMT

It formatted as long,lat

lat,long doesn't work

Re: Short Review of Geographic Mapping Options in QlikView

dena_reavis — Wed, 10 Sep 2014 14:52:25 GMT

Hi, I too am looking for documentation on the QlikView SVG Map. I downloaded the zip file, renamed to .qar, and installed successfully. But, I can't figure out what format my data should be in, like state name or state code or FIPS number or what?

Re: Re: Short Review of Geographic Mapping Options in QlikView

Josh_Good — Thu, 11 Sep 2014 22:08:30 GMT

Here is the SVG Map quick start guide. I'm not sure why it isn't included with the extension anymore.

Hope this helps,

Josh

Re: Short Review of Geographic Mapping Options in QlikView

dena_reavis — Wed, 17 Sep 2014 16:32:50 GMT

It was very helpful, thank you Josh!

Re: Short Review of Geographic Mapping Options in QlikView

rodrigue_saade — Wed, 05 Apr 2017 07:21:39 GMT

Hi Josh,

Which of the above work with QV12? I need a points map and area map.

Thank you in advance