Loading geo data Qlik Sense

ahaahaaha — Tue, 02 Feb 2016 13:28:59 GMT

Dear colleagues!

Qlik Sense Desktop. Create a map of the regions of Russia. Apply a layer of area. The file is downloaded RUS_adm1.kml (the file is attached, open the can, for example, the archiver RAR).

The code of the script is shown below.

Geo1:

LOAD

[.Name] as Name,

[.Area] as AreaPolygon,

RowNo() as ID,

rand()*10000 as SumSale

FROM [lib://Карты/Россия\RUS_adm1.kml]

(kml, Table is [Russia divisions. Level 1])

Where RowNo() < 27; //The string limit the number of records. The meaning of the text below.

If the number of records loaded not limit (all 85 records on the number of regions), in the formation of map issued in the mode of the application error "Hypercubic too many results".

If the number of records have been added to limit the number of 27 or less (the last line of the script), the map formed without any problems.

What could it be? Error code of the script? Error mode setting map application? Wrong KML file? Limitations of the Qlik Sense?

Yours faithfully

Andrey Kh.

Re: Loading geo data Qlik Sense

ahaahaaha — Tue, 02 Feb 2016 14:15:20 GMT

Similarly kml file for the next layer - of a total of 2445 records an error in the construction of map already there when downloading 700 entries and more.

Re: Loading geo data Qlik Sense

ahaahaaha — Tue, 02 Feb 2016 15:09:09 GMT

I found the discussion of this issue Qlik Sense Map Error: the hypercube results are too large"

t seems that this solution of the problem

topic Re: Loading geo data Qlik Sense in QlikView

Loading geo data Qlik Sense

Re: Loading geo data Qlik Sense

Re: Loading geo data Qlik Sense