topic Google Map - Multiple statistics in QlikView

Google Map - Multiple statistics

Wed, 27 Oct 2010 06:56:55 GMT

Hi,

in the dashboard that i have made for my project, i have used the Google map functionality. This was applied using the sample provided in the software. The google map shows total complaints in different areas of Karachi. The code is copied below. 'A Area' has 128 complaints so the diameter of the circle is relatively greater than B Area which has only 110 complaints.

I was wondering whether if i can present multiple statistics. e,g. Total Customers to be presented in another circle near to 'Complaints' circle.

What would be the code for that? any idea.

LOAD title,
latitude,
longitude,
count
FROM [file4map.qvo] (ansi, txt, delimiter is '\t', embedded labels, msq);

title latitude longitude complaints
A AREA 24.89869 67.05401 128
B AREA 24.87869 67.06401 110

Google Map - Multiple statistics

marcel_olmo — Wed, 27 Oct 2010 07:04:18 GMT

Hey Waqas,

could you be more specific?

What do you mean about multiple statistics?

As far as I know about your are telling, you have a big circle of 128 complains, and a little one of 110 complains.

What else do you expect for?

😉

Google Map - Multiple statistics

Wed, 27 Oct 2010 07:17:46 GMT

by no. of complaints, actually i was explaining the code that was appended.

My question was related with display of data. I mean can i load data from different files onto same map.

FILE 1:

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

LOAD title,
latitude,
longitude,
count
FROM [file4map.qvo] (ansi, txt, delimiter is '\t', embedded labels, msq);

file4map.qvo contains this data:

title latitude longitude complaints
A AREA 24.89869 67.05401 128
B AREA 24.87869 67.06401 110

FILE 2:

LOAD title,
latitude,
longitude,
complaints
FROM [file4comp.qvo] (ansi, txt, delimiter is '\t', embedded labels, msq);

file4comp.qvo contains this data:

title latitude longitude customers
A AREA 24.89000 67.05000 100500
B AREA 24.87000 67.06000 85000

Can the two files be presented in one single map?

Google Map - Multiple statistics

marcel_olmo — Wed, 27 Oct 2010 07:24:02 GMT

Yes, sure, with Qlikview you can load almost every data source you ever know.

Is Qlikview displaying you some kind of error loading data?

Google Map - Multiple statistics

Wed, 27 Oct 2010 20:17:29 GMT

Hi,

I understand you want to display 2 variables in the same locations (complaints & customer).

Do get this you should use the the size for complaints as you did & the color for the customers.

To set a color you have to create in the longitude expression (clik '+' background color) a new expression

example :

= if( avg(free) > 15 , color(1) , if( avg(free)> 5 , color(2) , color(3)))

regards