Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jul 19, 2022 3:05:40 AM
Mar 23, 2017 5:48:14 AM
Is it possible to load Shape (SHP) files into Qlik using Qlik GeoAnalytics and if so is any conversion required?
Qlik Sense Enterprise on Windows, all versions
Qlik GeoAnalytics / GeoAnalytics+ , all versions
Shape (SHP) files can either be loaded from a local file using Qlik GeoAnalytic+ or through an URL using Qlik GeoAnalytics Connector.
1. Copy the zipped shapefile attached to this article to any location (C:\tmp\CHE_Adm3.zip in this example)
2. Launch Qlik Sense, select Create new app and name the app. Press Create and Open app
3. Go to Data load editor and Create new connection
4. Select Qlik GeoAnalytics Connector
5. In the drop-down make sure to select GeoAnalytics Plus and give the connection a meaningful name
6. Press Test Connection to verify the connection and then Save
7. Press Select data
8. Set the following:
9. Press Next, and in the Select data to load check the tables Dataset_simplified as well as Dataset
10. Press Insert script to insert the script into the Data load editor
11. Press Load data to fetch the data into the data model
12. Once data has been loaded into the data model, create a new GeoAnalytics Map object and a GeoAnalytics Area Layer in a new sheet
13. Click Add dimension on the GeoAlaytics Area Layer and select the field Dataset_Simplified_Geometry
14. Verify the shapefile is shown correctly on the map
Note that there may be occasional issues with SHP file quality and the use of differing Coordinates Reference Systems.
Thanks @Bjorn_Wedbratt for all the details.
We were able to create connection using your article.
Only one thing missing seems - Java path update.
we struggled due to this, may be because of Java versions on our system.
We would recommend users to update the Java path in environment variables - so as to over come the connection issue.
I see that this process seems to go smoothly if one uses GeoAnalitycs...but any tips how to deal with it using GeoOperatoins?
Is there a way to transform the shape_leng, shape_area and Geometry into Latitude and longitude so it can be visualized?
Hello @JuMacedo
Please post about your query in detail in the Qlik GeoAnalytics forum, where our active users and support agents can better assist you.
All the best,
Sonja