Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have got a couple of questions.
I have attached my application which has 2 list boxes, 1 for the Origin Postal Code and the other for the Destination Postal Code.
When i do the selection, I show the distance between the 2 postal codes.
1. Now what I want to do is display the suburbs within the 5 kms radius based on the selection of my 1st list box. Is that possible?
2. I also want to show the equivalent map showing the suburbs within the 5kms radius.
Kindly someone who has worked on maps before please help.
Thanks,
Ram
Please Ramkumar:
Search and read any post about implementing Google Maps in QlikView.
Good luck.
CB.
Hi.
The problem is that your expression is 'static'.
First, remove all equal signs from your variables, to allow th expressions to be substituted instead of the calculated values.
Then correct the distance expression syntax to use the $-sign expansion and remove square brackets:
=Round(ACOS(SIN($(vLat1)*Pi()/180)*SIN($(vLat1As1)*Pi()/180)+COS($(vLat1)*Pi()/180)*COS($(vLat1As1)*Pi()/180)*COS(($(vLon1As1)*Pi()/180)-($(vLon1)*Pi()/180)))*6371)
Now, this expression can be used in charts to calculate the distance for each pcode.
Also you can now use it in set analysis to select the pcodes relative to 5 km radius.