Solved: how to write expression for google maps? - Qlik Community

buzzy996 · ‎2012-07-12

hi guys,

i have 500 records in a table along with country names.

i got GOOGLE MAP in qlick view along with records as india-400,china-100

but the things is,i need to disply onmap PERCENTAGE OF THOSE RECORDS!!!,HOW TO CALCULATE PERCENTAGE in expression?

formula:- number of records with respect to the country / total number of reocrds.

thx

Report Inappropriate Content · ‎2012-07-13

only you can answer

you can do count(key1)

but if there is only one location on each lon-lat you can do like i write before:)

buzzy996 · ‎2012-07-13

any help on this post?

Report Inappropriate Content · ‎2012-07-13

it will be easier if you'll post your file

you should have at least three expression

first two for long and latt

third one respond for the size of the mark on the map

jvitantonio · ‎2012-07-13

sum(country)/sUM(ALL Country)*100

buzzy996 · ‎2012-07-13

PFA,let me know any one ...

buzzy996 · ‎2012-07-13

any help on this?

Report Inappropriate Content · ‎2012-07-13

third expression should be

count(latitude)/count(total latitude)*100

buzzy996 · ‎2012-07-13

hi pari,

if u keep it like tht,system cann't understood how many records are cming frm DB?right...

i dont know,y ur telling the third expression shoul be count(latitude)/count(total latitude)*100?????can u explain more if ur sure abt that....

can find my sample above post,and show value on map .......please ....

thanks

Report Inappropriate Content · ‎2012-07-13

what i mean is the expression PartiPercentage shoul be count(latitude)/count(total latitude)*100

or count(latitude)/count(total latitude) and change number format to : show percentage

buzzy996 · ‎2012-07-13

thanks Pari,

but i one thing here,how qlickview undestanding the number of records by using latitude expression?pls exp a bit...