We are evaluating Qlik Sense for the maps requirements and I am stuck with this error " The Hypercube Results are too large" Error for Polygon Maps. No matter what I do - I get this error. I am trying to make polygon maps for Australia Postcodes and so far no luck. So here is what I have in my data load editor
"Australian Postcodes.Name" as Postcode,
FROM [lib://AusPost/Australian Postcodes.kml]
(kml, Table is [Australian Postcodes/Postcodes_Simplified]);
@1 as Postcode,
@2 as Suburb
(txt, codepage is 1252, no labels, delimiter is ',', msq);
GeoAggrGeometry("Australian Postcodes.Area") as Combined
group by Postcode;
Data loads fine but when I try to build the map I get this error.
When it asks me to select the dimension I select - "Postcode" and then the next step it asks me to "select a geographical field" then I select "Australian Postcodes.Area (area)" and I immediately get the error.
I even tried "Suburb" and "Australian Postcodes.Area (area)" and I immediately get the error.
I will really appreciate if someone can help me with this issue. This is a showstopper for my project and the client is ready to consider other tools look Tableau.
I even tried to reduce the KML file size by reducing the precision but after the the reduction, Qlik sense doesn't recognize column names of the KML file.( http://www.gearthblog.com/blog/archives/2016/03/making-kml-files-smaller-reducing-precision.html )
I am attaching both the files for your reference.
I am attaching a 3rd file as that is the one I have to use ultimately make the polygon maps ( third file name is - P_M_R_Final.csv)