topic Re: how to write expression for google maps? in QlikView

how to write expression for google maps?

buzzy996 — Thu, 12 Jul 2012 07:23:03 GMT

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

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 08:13:47 GMT

any help on this post?

Re: how to write expression for google maps?

Fri, 13 Jul 2012 08:15:58 GMT

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

Re: how to write expression for google maps?

jvitantonio — Fri, 13 Jul 2012 08:17:29 GMT

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

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 08:32:14 GMT

PFA,let me know any one ...

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 09:20:52 GMT

any help on this?

Re: how to write expression for google maps?

Fri, 13 Jul 2012 09:34:21 GMT

third expression should be

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

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 09:48:52 GMT

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

Re: how to write expression for google maps?

Fri, 13 Jul 2012 09:58:05 GMT

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

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 10:12:21 GMT

thanks Pari,

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

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 10:17:59 GMT

yes,ur right but when i selected FinYR from slection box values are not updating accordingly on map?

can i know wht was the cause?

Re: how to write expression for google maps?

Fri, 13 Jul 2012 10:25:52 GMT

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:)

Re: how to write expression for google maps?

buzzy996 — Fri, 13 Jul 2012 10:49:29 GMT

Thanks Pari

Re: how to write expression for google maps?

vikasmahajan — Sat, 28 Jul 2012 16:28:07 GMT

If you have sample demo for same please share for INDIA