Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikmaps Shape Files

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

8 Replies
MK9885
Master II
Master II

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.

adamdavi3s
Master
Master

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.

Not applicable
Author

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

Not applicable
Author

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.

adamdavi3s
Master
Master

GEOJSON is a particular format,

GeoJSON

take a look here:

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

adamdavi3s
Master
Master

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

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

MK9885
Master II
Master II

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

kuba_michalik
Partner - Specialist
Partner - Specialist

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