topic Google map with 2 measure/expressions in QlikView

Google map with 2 measure/expressions

Wed, 02 Mar 2011 15:36:04 GMT

Hi,

I am trying to track two measurables on a Google maps app.

For example, could you have two sets of scatter dots on one map. Say one red, which tracks no. of students that registered and another green with number of students that applied.

I have attached the example I am working.

Any help would be appreciated!

Thanks!

Google map with 2 measure/expressions

Thu, 03 Mar 2011 12:10:24 GMT

Any ideas?

Google map with 2 measure/expressions

Thu, 03 Mar 2011 21:05:55 GMT

Technicaly you can't !

Even if you could, how do you manage the overlap of information in the same point.

I suggest you to use a size to figure number of students and a color for the second variable.

In your app, you are close to the solution. For the color , create an expression in the backgroung color of longitude :

if ( sum( enrolled) > 50 , color(1) , color(2) ) for 2 colors. You can use also the colormix wizard (edit expression of backgroung color then go to file menu) to get a shade of colors.

Hope it helps you