Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

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

Highlighted
Employee
Employee

Re: How to use shape file in Qliksense?

Hi,

Please check the tutorial:

Loading Esri shapefiles in Qlik GeoAnalytics

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

Thanks,

Patric

Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

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.

Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

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

Highlighted
Employee
Employee

Re: How to use shape file in Qliksense?

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

Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

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?

Highlighted
Creator II
Creator II

Re: How to use shape file in Qliksense?

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

Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

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

Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

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 ----------------------------------- */

Highlighted
Specialist
Specialist

Re: How to use shape file in Qliksense?

Hey Rod,

Can you help me in this?