Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Polygon Map at the Postcode Level For Australia

Using the Maps Chart Object - Polygon Map - Part 2 - (video)

@Michael Tarallo - Is it possible to draw a polygon chart at the postcode level for whole Australia Using Qlik Sense?

I am stuck with this issue and no matter what I do , I get the error . If it is not possible then please do let me know and I will start concentrating on Qlik View . I am attaching the app and the data for your reference.

8 Replies
robert99
Not applicable

Re: Polygon Map at the Postcode Level For Australia

Have you tried everything in this thread

Qlik Sense Map Error: the hypercube results are too large"

including this

I eventually found this site for reducing the number of decimals

http://www.gearthblog.com/blog/archives/2016/03/making-kml-files-smaller-reducing-precision.html

It's free and did the job very quickly. Highland reduced from around 3 million characters to 1.5 million based on 5 decimal places. (4 distorted the map slightly or a lot with 3 or less). I also used "optimize KML file size" (US$20). It reduced the number of characters slightly for Highland but not much. But using both worked OK. That is reduce the decimal's to 5 and then run optimize.

I tried Qlik's geogetboundingbox with 15 decimal places but it still didn't work.

Re getAggrGeomentry. I tried this and it increased the number of decimals back up to 15. So instead I just grouped greater London using the visualization grouping facility. Even though it still showed the boundaries (like GetReduceGeometry).

Not applicable

Re: Polygon Map at the Postcode Level For Australia

Yes Robert,

I tried both of them.

1. If I use GeoAggrGeometry function then the data load runs for hours and ultimately it errors out and qlik sense dies.

2. After reducing the precision in the KML file, Qlik sense doesn't recognize the columns specified in the KML file.

Thanks

Aj

robert99
Not applicable

Re: Polygon Map at the Postcode Level For Australia

I guess you have too many areas (2513)

It works if I took areas starting with 0 then 1 then 2 etc. But if I add them together and it exceeds 1000 it doesn't. So maybe the maps can only handle an upper limit of areas.

I hope Qlik markedly improve mapping (including the documentation) in version 3. These maps are excellent but it can take forever to get them set up and working

Not applicable

Re: Polygon Map at the Postcode Level For Australia

Thanks Robert, Appreciate the response.

From which file you removed areas – KML or P_M_R_A_Final_Decile_W.csv. Because I need the maps only for the postcodes which are in the file P_M_R_A_Final_Decile_W.csv. And they are totally – 1321.

Thanks

Aj

robert99
Not applicable

Re: Polygon Map at the Postcode Level For Australia

LOAD1:

LOAD

    "Australian Postcodes.Name",

   

    IF (wildmatch  ("Australian Postcodes.Name"  , '3*'   )  >0 , 'Are3' ,

if (wildmatch  ("Australian Postcodes.Name"  , '2*' ) , 'Area2',

if (wildmatch  ("Australian Postcodes.Name"  , '1*'   ) > 0, 'Area1', 'other'))) as AreaCom ,

    "Australian Postcodes.Point",

   

    GeoGetBoundingBox  ("Australian Postcodes.Area") as geoarea ,

    "Australian Postcodes.Area"

FROM [lib://Downloads/AustKML\Data_And_App\Australian Postcodes.kml]

(kml, Table is [Australian Postcodes/Postcodes_Simplified])

WHERE wildmatch  ("Australian Postcodes.Name"  , '3*' , '2*' , '1*'   )

//WHERE match  ("Australian Postcodes.Name" , 3212)

;

If I just loaded starting with 0 it was fine. Likewise with 1 to 10. But combining 2 or more numbers ('3*' , '2*' , '1*')  often did not work. As didn't the other options I tried

lms
Not applicable

Re: Polygon Map at the Postcode Level For Australia

Hi Again Ajay. You have been busy on this issue. Just so that community users can find their way to a solution from your various posts, I will put a couple of links here.

Please refer to my comments in this post: Re: Unable to Create Polygon Map for Australia

And the files attached to this post: Re: How to find Australian Postcode KML file

Lech_Miszkiewicz
Not applicable

Re: Polygon Map at the Postcode Level For Australia

Hi Ajay

Use the KML [*reduced size] file i have posted in here.. Filename = Postcodes.kml

GeoAggrGeometry() - JSON protocol parse error

It will plot Australia postcodes.

There are also links to GDAL tool to reduce KML accuracy in order to get it working in QlikSense build-in MAp chart

hope this helps

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Not applicable

Re: Polygon Map at the Postcode Level For Australia

Thanks Lech,

We ultimately used GDAL tool to fix that issue. Appreciate your response.

Regards

Ajay