Geographical Report Creation

[#1]

Hello everyone,

I have sales data by country like shown below:

Country	Sales
FR	$45,354.00
GE	$545,435.00
BL	$54,534.00
AUS	$545.00
NZ	$345.00
USA	$45,545.00
IND	$54,534.00
SPA	$5,454.00

I would like show my report in the geographical view. could you please help me how to do this one ?

Thanks and Regards,

Robert

[jagan]

Hi,

please check attached sample file for solution.  Hope it helps you.

Regards,

Jagan.

[#3]

Hi,

Thanks for your reply.

I didn't find any attachment. could please attach it again?

Regards,

Robert

[jagan]

Hi Robert,

Sorry missed attachment.  PFA.

Regards,

Jagan.

[#5]

Hi Jagan,

do you have any other option to show map rather than Google map.

For instance,  we option in SSRS to create geographical report, you have to use the zip code to map the data in order to plot on Map.

I want show only SEA countries  in my map. do you have any more suggestion.

Regards,

Robert

[jagan]

Hi,

You just get the Latitude and Longitudes of your locations, based on that the map automatically generates.  If you have only SEA countries then you will get only that map.

Regards,

Jagan.

[#7]

Hi,

As per your suggestion, i have got Latitude and Longitudes of my locations, updated into the load data as well and I have loaded another table which has Sales data by country.

My aim to be display the sales data on the map(plot on the map in different colors) and also i am seeing the cities in map but i want to display only the country of my customized in small text.

I have attached the updated qvw file for your reference.

Sorry i am very new to QlikView so getting lots of doubt.

Regards,

Robert