How to use shape file in Qliksense?

[nikhilgarg]

Hello All,

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

[nikhilgarg]

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

[Patric_Nordstrom]

Hi,

Please check the tutorial:

Loading Esri shapefiles in Qlik GeoAnalytics

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

Thanks,

Patric

[nikhilgarg]

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.

[nikhilgarg]

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

[Patric_Nordstrom]

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

[nikhilgarg]

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?

[Anonymous]

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

[nikhilgarg]

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

[nikhilgarg]

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

[nikhilgarg]

Hey Rod,

Can you help me in this?