topic Map data loading Qlik Sense in App Development

Map data loading Qlik Sense

Wed, 29 Apr 2015 14:26:17 GMT

Hello,

I used the function "GeoMakePoint" to create point for the Map object with longitudes and latitudes. The points can be filtered by city and zip code.

When I load the map object only some points are loaded but if I select a city or zip code (filtering), the correct amount of points are loaded.

I have a data model like this:

Client :

Street name - Zip Code : GPS link
Street name
Zip Code

GPS data:

Street name - Zip Code : GPS link
Latitude
Longitude
City
Zip Code
GeoMakePoint(latitude, longitude)

I figured out that if I modify my key "GPS link" may be the problem but I couldn't fix it. If I do hash128(Street name - Zip Code) (to avoid bad characters into my street name), the points displayed in the map are not the same anymore (still not the correct number of point).

Do you have any idea ?

Thanks

Re: Map data loading Qlik Sense

Wed, 29 Apr 2015 14:51:07 GMT

Hi Guillaume,

How many data points there in your data model, unfiltered?

Re: Map data loading Qlik Sense

Thu, 30 Apr 2015 07:30:14 GMT

About 1000 different points with 3 different zip code

Re: Map data loading Qlik Sense

Thu, 30 Apr 2015 09:16:24 GMT

I had an issue with a scatter chart with > 1000 data points, which would fail to render until I reduced the number of data points < 1000. As I understand it, the current version of QlikSense (1.1) has a limit on some visualisations, where it will not render a data set larger than 1000 data points. One way to check is to load your data into a table and, if the fields all look correct, then this is likely to be the cause of your problem.

As I understand, there is work being done on this at the moment, I'd recommend giving someone at Qlik a call about your specific scenario.

Re: Map data loading Qlik Sense

joeybird — Fri, 01 May 2015 13:46:35 GMT

Hiya

I don't know if it will help as still new to this, I call my customers details from SQL...but to get my map working I created a separate excel sheet.

then in the data load editor as a separate section added

these are my three main columns

CityLatitude,

CityLongitude,

StreetName,

LOAD

CityLatitude,

CityLongitude,

StreetName,

GeoMakePoint (CityLatitude,CityLongitude) as StreetLocation

FROM [lib://Sense/CustomerLocations.xlsx]

(ooxml, embedded labels, table is Sheet1);

Kind Regards

Joeybird