Data in GeoAnalytics

d_ankusha — Tue, 09 Oct 2018 12:36:13 GMT

Hi All,

Can anyone guide me how to make data consistent for GeoAnalytics? I have multiple entries for City, State and Country for pickup and delivery , but the data have lots of missing fields and null values. Also some of the fields have wrongly associated values with different types of inputs.

So what can be the best practice for getting proper data for Geo-Analytics implementation?

Re: Data in GeoAnalytics

Patric_Nordstrom — Mon, 15 Oct 2018 13:33:00 GMT

Hi,

Yes, the process of handling bad location input data is topic for several blog posts. However, here's some advice:

Add country code to the locations string (or use the drop down): 'New York, US'
Add location type to locations string (or use the drop down): 'New York,US:P*' to get hits on the city not the state
Use codes when possible (country, region etc) names are often spelled wrong
Remove any trash in the location string
Use NamedPointLookup and NamedAreaLookup to flush out mismatches when the data is loaded
Check the QGA coverage to expect per country
Buy Qlik Geocoding to get matching to street address number level

Read more how the Location Service works:

https://bi.idevio.com/products/idevio-maps-for-qlik-sense/documentation

Try the NamedPointLookup Example at

https://bi.idevio.com/geoanalytics/geoanalytics-connector-examples

Thanks,

Patric

topic Re: Data in GeoAnalytics in GeoAnalytics

Data in GeoAnalytics

Re: Data in GeoAnalytics