topic Re: Changes in SVG map based on value selected in a listbox in QlikView

Changes in SVG map based on value selected in a listbox

Wed, 25 Nov 2020 16:16:04 GMT

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

(ooxml, embedded labels, table is [cdh_download_10-10-2013]);

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

Re: Changes in SVG map based on value selected in a listbox

BalaBhaskar_Qlik — Fri, 07 Jul 2017 14:11:24 GMT

Try this:

SvgReader mapping extension now stored on GitHub

Re: Changes in SVG map based on value selected in a listbox

Mon, 10 Jul 2017 06:02:48 GMT

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

Re: Changes in SVG map based on value selected in a listbox

Mon, 10 Jul 2017 06:04:15 GMT

Sorry I missed the attachement.