topic Re: How to use shape file in Qliksense? in GeoAnalytics

How to use shape file in Qliksense?

nikhilgarg — Tue, 22 May 2018 09:06:18 GMT

Hello All,

Can anyone help em knowing how to use/load shape files in Qliksense for geoMaps?

Re: How to use shape file in Qliksense?

Patric_Nordstrom — Tue, 22 May 2018 12:40:05 GMT

Hi,

Please check the tutorial:

Loading Esri shapefiles in Qlik GeoAnalytics

Thanks,

Patric

Re: How to use shape file in Qliksense?

nikhilgarg — Tue, 22 May 2018 13:12:33 GMT

Do i need to download some QGA connector for this? OR does it works fine without that?

Re: How to use shape file in Qliksense?

Anonymous — Tue, 22 May 2018 21:49:36 GMT

Yes, you need the QGA connector that comes with the standard download and is installed by running the included installation executable. e.g. GeoAnalyticsSetup_April_2018_Patch_1.exe

Note that the first of the instructions in the tutorial says "Open the connector and choose "Simplify"", this is referring to he QGA connector and the operation that can be chosen from a drop down list at the top of the connector interface.

Cheers,

Rod

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 03:17:07 GMT

Okay, I am running licensed feb 2018 version of geo analytics. But could

not find any QGA.

Re: How to use shape file in Qliksense?

Anonymous — Wed, 23 May 2018 03:21:01 GMT

Can I ask where you have looked? Do you know if the installation for the connector was run or have you just imported the extensions? Can I assume Qlik Sense Server is being used?

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 03:59:50 GMT

Hey Rod,

I am pretty new to geomaps. So, I am assuming when I installed licensed

geoanalytics, this QGA connector should have run. Pls correct me if I am

wrong and let me know where can I find QGA connector?

Re: How to use shape file in Qliksense?

Anonymous — Wed, 23 May 2018 04:21:58 GMT

Ok, so assuming you are using Qlik Sense server and setting QGA for that, from the download site you should have downloaded a file something like "GeoAnalyticsForQlikSenseServer-April2018p1.zip" (that's the latest).

When you unzip that file you'll find an exe file, a bunch of zip files for the QGA extensions that you need to install and a "doc" directory. In the doc directory you'll find a "inst_guide_qss.html" that you can open and will give you installation instructions.

Once you have followed those you should be able to access the QGA connector from within an app. So if you open an app and navigate to the Data Load Editor and click the "Create new connection" button, you should now see the "Qlik GeoAnalytics Connector" in your list of available data sources. There is other documentation in the aforementioned "doc" directory called "user_guide -...." that will get you started from there.

Hope that helps.

Cheers,

Rod

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 06:43:41 GMT

Hey Rod,

Thanks, this helps. I found the QGA Connector in my data connections. I tested the connection selecting 'AUTO'. But when i click on insert data, a window pop up and i really dont know what to fill. Can you help me in this? I am using Shape file at territory level

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 06:48:52 GMT

Hey Rod,

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 06:49:41 GMT

Hey PAtrick,

T I found the QGA Connector in my data connections. I tested the connection selecting 'AUTO'. But when i click on insert data, a window pop up and i really dont know what to fill. Can you help me in this? I am using Shape file at territory level. Pls find attached snapshot for the same

Re: How to use shape file in Qliksense?

Patric_Nordstrom — Wed, 23 May 2018 07:01:53 GMT

Hi,

Please check the tutorial:

Loading Esri shapefiles in Qlik GeoAnalytics

It shows step by step on how to load the shapefile.

Thanks,

Patric

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 07:16:20 GMT

Hey Patric,

I am following your steps but could not find any similarity between your steps and my situation.

When i open the QGA connector, it ask for Connection name. By default 'Custom ' is selected.

If i choose 'Auto', it does not asks for any URL to fill. Pls. guide.

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 07:17:38 GMT

Hey Patric,

I am following your steps but could not find any similarity between your steps and my situation.

When i open the QGA connector, it ask for Connection name. By default 'Custom ' is selected. IOf i choose 'Auto', it does not asks for any URL to fill. Pls. find attached snapshot and guide

Re: How to use shape file in Qliksense?

Patric_Nordstrom — Wed, 23 May 2018 07:34:11 GMT

Hi Nikhil,

When in doubt choose "Auto". The other options are for customers with their own QGA server.

After that you will get to the main connector dialogue, choose "Load" or "Simplify" and follow the guide.

More info about the connector:

Qlik GeoAnalytics Connector intro

Guides & Examples

GeoAnalytics for QV tutorial, TravelAreas, Closest, Dissolve

Thanks,

Patric

Re: How to use shape file in Qliksense?

nikhilgarg — Wed, 23 May 2018 09:21:19 GMT

Hey Patrick,

Thanks this helps. I am able to configure with Simplify Keyword. But after inserting the query, i find the query is a bit different. My query is:

[Dataset_Simplified]:

SQL SELECT [LocationDbId], [Dataset_Simplified_Geometry] FROM Simplify(resolution='Auto', dataset='Dataset')

DATASOURCE Dataset LOCATIONSERVICE geometry='AREA', type='APCLI', country='', serviceName='default'

SELECT [Dataset_Name], [Dataset_Geometry], [CountryIso2], [Dataset_Adm1Code], [Dataset_Adm2Code], [LocationDbType], [LocationDbId] FROM Dataset;

[Dataset]:

SQL LOAD * FROM Dataset;

tag field LocationDbId with '$primarykey';

tag field Dataset_Simplified_Geometry with '$geopolygon';

tag field LocationDbId with '$geoname';

tag field Dataset_Simplified_Geometry with '$relates_LocationDbId';

tag field LocationDbId with '$relates_Dataset_Simplified_Geometry';

tag field LocationDbId with '$primarykey';

tag field Dataset_Geometry with '$geopolygon';

tag field LocationDbId with '$geoname';

tag field Dataset_Geometry with '$relates_LocationDbId';

tag field LocationDbId with '$relates_Dataset_Geometry';

/* End GeoAnalytics operation Simplify ----------------------------------- */

I have no clue where to put URL Keyword. I tried putting URL keword with its value before "LOCATION SERVICE" keyword, but it fails. My shape file is in local server i.e. under C:/

Can you help me in this?

Re: How to use shape file in Qliksense?

Anonymous — Thu, 24 May 2018 02:16:15 GMT

Hi Nikhil,

What license do you have? With the basic QGA license you won't be able to load a shape file from a local directory, you'll have to load it from a web hosted URL. One way around this is to put your shape file in a cloud hosted file storage such as box.com or similar and then ascertain the correct URL to load it from.

If however you have the Geoanalytics plus license and have installed Geoanalytics plus you can load shape files from local storage using "file:///c:\myPath" syntax.

Geoanalytics plus is supplied as a separate installation file you need to download from the customer download site. If you aren't sure whether you are licensed for it I encourage you to ask your Qlik account manager for clarification.

Cheers,

Rod

Re: How to use shape file in Qliksense?

nikhilgarg — Thu, 24 May 2018 05:44:39 GMT

Hey Rod,

I dont have QGA Plus connector. I have only QGA Connector. So, i guess i need to put my file on dropbox and then load it from there. LEt me try this

Re: How to use shape file in Qliksense?

nikhilgarg — Thu, 24 May 2018 07:25:32 GMT

Hey Rod,

I am trying to use with Google Drive, but i exactly dont know what changes to done in the script below: Can you help me where i need to put up the URL?

Script:

[Dataset_Simplified]:

SQL SELECT [LocationDbId], [Dataset_Simplified_Geometry] FROM Simplify(resolution='Auto', dataset='Dataset')

DATASOURCE Dataset LOCATIONSERVICE geometry='AREA', type='APCLI', country='', serviceName='default'

SELECT [Dataset_Name], [Dataset_Geometry], [CountryIso2], [Dataset_Adm1Code], [Dataset_Adm2Code], [LocationDbType], [LocationDbId] FROM Dataset;

[Dataset]:

SQL LOAD * FROM Dataset;

tag field LocationDbId with '$primarykey';

tag field Dataset_Simplified_Geometry with '$geopolygon';

tag field LocationDbId with '$geoname';

tag field Dataset_Simplified_Geometry with '$relates_LocationDbId';

tag field LocationDbId with '$relates_Dataset_Simplified_Geometry';

tag field LocationDbId with '$primarykey';

tag field Dataset_Geometry with '$geopolygon';

tag field LocationDbId with '$geoname';

tag field Dataset_Geometry with '$relates_LocationDbId';

tag field LocationDbId with '$relates_Dataset_Geometry';

/* End GeoAnalytics operation Simplify ----------------------------------- */

Re: How to use shape file in Qliksense?

nikhilgarg — Sat, 26 May 2018 07:08:29 GMT

Hey Rod,

Can you help me in this?