Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have loaded the below script.
Data:
LOAD * INLINE [
Booked, Managed, Revenue
France, Spain, 100
France, Canada, 200
France, India, 250
France, France, 180
India, India, 200
Germany, India, 170
Chile, India, 80
];
ISO:
LOAD Booked,
Managed,
[ISO 3166-2 Sub-division/State Code],
[ISO 3166-2 Subdivision/State Name],
[ISO 3166-2 Primary Level Name],
[Subdivision/State Alternate Names],
[ISO 3166-2 Subdivision/State Code (with *)],
[Subdivision CDH ID],
[Country CDH ID],
[Country ISO Char 2 Code],
[Country ISO Char 3 Code]
FROM
(
The columns Booked & Managed in ISO table are exactly identical to join the ISO codes to Booked & Managed columns in Data table. I have added the SVG map extension and turned on the web view. I need a list box for column Booked where for the country I select it's corresponding countries under Managed with it's Revenue will be shown in the world map.
Can you please help me out.
Regards,
Ayandeep
Hi Bala,
Sorry, but the contents of the link you shared doesn't help much. I am sharing the QVW file I have created.
What I need is if I select France in the listbox created using filed Booked it's corresponding countries under the field Managed should be coloured on the map based on the Revenue values.
Regards,
Ayandeep
Sorry I missed the attachement.