Hello
I am trying to solve a complex problem in QlikView using maps.
Background:
In my data set that is a single excel data file I have 6 data feilds with following names - Lat1, Long1, Lat2, Long2, Lat3, Long3
These data columns contain latitude and longitude in them.
I have other three data fields Opt1, Opt2, Opt 3 (Option data fields) which contains values 1 or 0
Data:
So the data looks like this in my excel sheet:
| Opt1 | Lat1 | Long1 | Opt2 | Lat2 | long2 | Opt3 | Lat3 | Long3 |
|---|
| 1 | 55 | -1.522816 | 1 | 45 | -1.5342 | 0 | 46 | -1.6788 |
| 0 | 60 | -1.513281 | 1 | 35 | -1.5782 | 0 | 23 | -1.7234 |
| 1 | 65 | -1.465094 | 0 | 25 | -1.5834 | 1 | 45 | -1.8654 |
| 1 | 70 | -1.465453 | 0 | 51 | -1.5888 | 1 | 69 | -1.5761 |
QlikView Objects: Now I need to have a UK map in Qlikview and a drop down box that contains option - Option1, Option2, Option3.
Action:
- When I select Option1 from the drop down list then the map should show only the Lat1 and Long1 locations on the UK map that have Opt1 value equal 1.
- When I select Option2 from the drop down list then the map should show only the Lat2 and Long2 locations on the UK map that have Opt2 value equal 1.
- When I select Option3 from the drop down list then the map should show only the Lat3 and Long3 locations on the UK map that have Opt3 value equal 1.
**I tried to use the google maps but I need to have some key and when I search for that key the google web page says that they are not available**
Kindly help, If you need more info please let me know. I will provide more details.
