topic Re: Problem with this scatter Map in QlikView

Problem with this scatter Map

ecabanas — Tue, 16 Jul 2013 14:20:40 GMT

Hi,

I'm trying to fix, but, no data appears, any help?

thank's

Re: Problem with this scatter Map

jerem1234 — Tue, 16 Jul 2013 15:04:56 GMT

You have the expression:

=sum( round (256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )

but you do not have a variable var_zoom declared or defined.

Re: Problem with this scatter Map

ecabanas — Tue, 16 Jul 2013 15:53:14 GMT

now it's loaded the varzoom andstill not working

Re: Problem with this scatter Map

jerem1234 — Tue, 16 Jul 2013 15:59:31 GMT

Seems like your latitude and longitude were in text format.

Here use these expressions:

Longitude:

=sum( num(round (256*pow(2,($(var_zoom)-1)))+num#(longitude, '#.##0.00000')*((256*pow(2,$(var_zoom)))/360), '#.##0.00000') )

Latitude:

=sum(num( ((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((num#(latitude, '#.##0.00000'))*pi()/180)))/(1-(sin((num#(latitude, '#.##0.00000'))*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))), '#.##0.00000'))

Hope this helps.

Re: Problem with this scatter Map

ecabanas — Tue, 16 Jul 2013 16:08:19 GMT

Hi Jerem

Now its starting to work, but only if you choose only one longitude...

Re: Problem with this scatter Map

jerem1234 — Tue, 16 Jul 2013 17:23:35 GMT

Try to watch where you put mins and maxes, try this expression for your variable var_zoom:

=max(aggr(if(round(256*pow(2,(max(_zoom_level) -1)))+( max(longitude) *((256*pow(2,max(_zoom_level) ))/360)) - round(256*pow(2,(min(_zoom_level) -1)))+( min(longitude) *((256*pow(2,min(_zoom_level) ))/360)) <400 AND (256*pow(2,(max(_zoom_level)-1)))+((0.5*log((1+(sin((max(latitude))*pi()/180)))/(1-(sin((max(latitude))*pi()/180)))))*((-256*pow(2,max(_zoom_level)))/(2*pi())))- (256*pow(2,(min(_zoom_level)-1)))+((0.5*log((1+(sin((min(latitude))*pi()/180)))/(1-(sin((min(latitude))*pi()/180)))))*((-256*pow(2,min(_zoom_level)))/(2*pi())))<400,_zoom_level,null()),_zoom_level))

Look over where i put the mins and maxes to see if thats what you wanted.

Re: Problem with this scatter Map

ecabanas — Wed, 17 Jul 2013 07:33:36 GMT

Hi Jerem,

I tryed and now appears, a dot, but no map image in background, you know

why? it is very very difficult to work, at the end is easier an extension,

no?

Thanks

Eduard

2013/7/16 jerem1234 <qcwebmaster@qlik.com>

**
QlikCommunity <http://community.qlik.com/index.jspa>
Re: Problem with this scatter Map created by jerem1234<http://community.qlik.com/people/jerem1234>in
Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/368534#368534>

Re: Problem with this scatter Map

jerem1234 — Wed, 17 Jul 2013 12:48:55 GMT

Not exactly sure why, there are a lot of calculations going on. Could be a mistake somewhere in one of them such as the static maxes or mins. But an extension would probably be easier, just search around the Qlikcommunity site to find posts about extensions, they are out there.