I am not able to open ur qvw file, bez I am using personal edition.
I have attached my sample, PFA.
Googlemap.qvw 181.8 K
Hi Kabilan ,
Thanks for ur Quick reply.i saw ur file and the expressions.
Actually my requirement is if i select any state in india the cities under those state should get populated in the map with their sales as data points.
1)I got lat and log for every cities in india.and for every cities they have their own sales .
But i am still getting struct with this lat and log expressions .Any suggestion about this .
And Attached is the sample excel which iam trying to acheive.
Section Access.xlsx 17.8 K
You have two problems in your application :
1) there's more than one latitude and one longitude per city in your file, so when you load this table you need to use the command "distinct" like this :
LOAD distinct [Region Code],
Branch as City,
[D:\mohan\Qlikview Training Material\Section Access\Section Access\Section Access.xlsx]
(ooxml, embedded labels, table is Branch);
2) in the chart properties, in the Axes tab, you need to uncheck the option "Forced 0" for the X absis and the Y absis
Hope it helps.
Its working.I am missing the second step uncheck 'force0' .But ur first suggestion not worked out.i have tried distinct in the script.But Even though the data points on the map is not on the proper location .
Is there any way to make the data points to sit on the same location in the map?