Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

melghandour89
Not applicable

How can I deal with big data like 200000 [long,lat] ?

Hi all,

I've case here to deal with 200000 [long, lat] I try to displaying them but the App get hang , what is the best practice ?

also how can i aggregate them all point take one of three status {new,old,renew}

8 Replies
lironbaram
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

hi

your best solution will be to use cluster function

look at this tutorial

GeoAnalytics Cluster Guide - Google Slides

melghandour89
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

Hi ,

Thanks for your response ,

I'll try this solution and let you now if it work

melghandour89
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

I'm go through the document and find the Binning is the best for me I loaded the table but I don't know how to use it with idevio map, do you have any example

Patric
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

Hi Mahmoud,

Check out the connector examples here, there is one for binning:

Guides & Examples « bi.idevio.com

Thanks,

Patric Nordström

Qlik

melghandour89
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

Hi Patric ,

That's what I'm searching about but unfortunately all links Example not working

Patric
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

IE user? Use Save target as … to download, rename to .qvf file, place the qvf file in Sense Apps folder. Although the examples are made with Qlik Sense the load script code will work in QlikView too.

melghandour89
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

Hi Patric ,

What If customer need to load all 200 K point on the map without using neither drill down nor cluster, so the idevio map get hang

I asked to increase the memory to 32 GB also, it get hang

Please advise

Many Thanks

Patric
Not applicable

Re: How can I deal with big data like 200000 [long,lat] ?

Well, I wouldn't recommend it but it will eventually render.

200k.png

It's of course much better to moderate the information density to be constant at all scale levels, here's nice example of US traffic incidents, shown on incident, hex bin, and county level.

Gartner2017.jpg

Nice to look at, fluid to interact with and renders quickly. Built with the Binning and SpatialIndex operations.

See the live demo at qlikdemo.idevio.com

Thanks,

Patric

Community Browser