Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display the names of the Suburbs within a radius of 5 kms

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

2 Replies
carbal1952
Creator II
Creator II

Please Ramkumar:

Search and read any post about implementing Google Maps in QlikView.

Good luck.

CB.

whiteline
Master II
Master II

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.