Google Map - Date as dimension

Wed, 07 May 2014 18:55:34 GMT

I have a google map created using a scatter graph.

My data looks like excel file table attached.

The issue I keep running into is that since I have multiple longitude/latitude values for the same area, my expression SUMS them together if I don't have a date selected. I want to be able to see all data points, regardless of date, but be able to narrow down to a date if necessary.

How can I modify the expression to stop this from happening? I was thinking I needed to add an aggregate to it but I'm not sure how.

my latitude and longitude expression formulas are as follows:

latitude:

sum(((256*pow(2,($(var_zoom)-1)))+((0.5*

log((1+(

sin((

latitude)*

pi()/180)))/(1-(

sin((

latitude)*

pi()/180)))))*((-256*

pow(2,

$(var_zoom)))/(2*

pi())))))

longitude:

sum( round (256*pow(2,($(var_zoom)-1)))+(

longitude *((256*

pow(2,

$(var_zoom)))/360)))

Re: Google Map - Date as dimension

Fri, 09 May 2014 14:06:21 GMT

Use average instead of sum.

topic Re: Google Map - Date as dimension in QlikView

Google Map - Date as dimension

Re: Google Map - Date as dimension