topic Re: Qlikmaps Shape Files in QlikView

Qlikmaps Shape Files

Wed, 25 Nov 2020 16:16:04 GMT

Currently I am using QGIS tool to generate the shape files for my Qlikmap reports.

While creating the shape files for differnent territories\State\Area there is one step to dissolve it. Dissolving any shape files is taking a lot of time(Around 2-3 days) .

Is there any way can we do it faster?

Will appreciate your help.

Thanks

Agrawalla

Re: Qlikmaps Shape Files

MK9885 — Wed, 30 Nov 2016 15:09:09 GMT

I believe .SHP files will not work in Qlik View/Qlik Maps.

You would need KML files to load the boundaries for State or Area.

Have you already tried loading .SHP files in Qlik Maps and checked if you can see the boundaries for polygon map?

.SHP/MKL files can be only used for polygon map.

For bubble/points map you can do it by Latitude & Longitude.

Re: Qlikmaps Shape Files

adamdavi3s — Wed, 30 Nov 2016 15:19:22 GMT

Hi Agrawalla,

I share your pain!

I explored a lot of options and in the end I created co-ordinate sets to create polygons which I then used.

The extension can't handle loads at once, maybe 100ish tops before it starts to crash out.

I was lucky in that I found some GEOJSON files with the boundaries in them which I could then extract and create the necessary coordinates.

Re: Qlikmaps Shape Files

Fri, 02 Dec 2016 09:50:44 GMT

Thanks for your reply.

Once the shape file created, then I convert them into .csv file using QGIS plugins. In Qlikmap I use the .csv file not the shape files directly.

Is there any way we can create the .shp file fast?

Thanks

Re: Qlikmaps Shape Files

Fri, 02 Dec 2016 09:53:14 GMT

Hi Adam,

Thanks for the reply.

how GEOJSON is different from QGIS? Also how much time does it take while dissolving any shape files in GEOJSON?

Also wanted to know if GEOJSON is open source or paid software.

Thanks.

Re: Qlikmaps Shape Files

adamdavi3s — Fri, 02 Dec 2016 10:52:04 GMT

GEOJSON is a particular format,

GeoJSON

take a look here:

india/india_district.geojson at master · geohacker/india · GitHub

Re: Qlikmaps Shape Files

adamdavi3s — Fri, 02 Dec 2016 12:14:14 GMT

I've just blogged some of the stuff I have done recently

http://qlikanddirty.com/2016/12/02/sql-geography-and-geojson/

Re: Qlikmaps Shape Files

MK9885 — Fri, 02 Dec 2016 12:56:09 GMT

If you've Alteryx software (Paid) then it will much faster and easier.

However you can Geocode 1000 data points for free (I guess).

Alteryx Analytics Gallery

Re: Qlikmaps Shape Files

kuba_michalik — Fri, 02 Dec 2016 14:07:53 GMT

I'm not sure what your workflow is from the description. Dissolve merges shapes based on an attribute value, as far as I understand. If QGIS is slow with that, there are certainly alternatives - like using v.dissolve in GRASS (you can get QGIS with GRASS), or even trying to use QlikSense just for that - export your KML without dissolving (it will likely be huge and way too big to be used directly in maps), then after loading into Sense aggregate with GeoAggrGeometry or GeoReduceGeometry