Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ahaahaaha
Partner - Master
Partner - Master

Loading geo data Qlik Sense

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".

Error.png

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.

Map.png

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.

2 Replies
ahaahaaha
Partner - Master
Partner - Master
Author

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.

ahaahaaha
Partner - Master
Partner - Master
Author

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