Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Problem with this scatter Map

Hi,

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

thank's

7 Replies
jerem1234
Specialist II
Specialist II

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.

ecabanas
Creator II
Creator II
Author

now it's loaded the varzoom andstill not working

jerem1234
Specialist II
Specialist II

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.

ecabanas
Creator II
Creator II
Author

Hi Jerem

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

jerem1234
Specialist II
Specialist II

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.

ecabanas
Creator II
Creator II
Author

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>

jerem1234
Specialist II
Specialist II

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.