Google Map - Multiple statistics

[#1]

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

[marcel_olmo]

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?

😉

[#3]

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?

[marcel_olmo]

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

Is Qlikview displaying you some kind of error loading data?

[#5]

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