topic Geographical Report Creation in QlikView

Geographical Report Creation

Fri, 26 Sep 2014 02:53:05 GMT

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

Re: Geographical Report Creation

jagan — Fri, 26 Sep 2014 03:09:22 GMT

Hi,

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

Regards,

Jagan.

Re: Geographical Report Creation

Fri, 26 Sep 2014 03:13:51 GMT

Hi,

Thanks for your reply.

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

Regards,

Robert

Re: Re: Geographical Report Creation

jagan — Fri, 26 Sep 2014 03:23:46 GMT

Hi Robert,

Sorry missed attachment. PFA.

Regards,

Jagan.

Re: Geographical Report Creation

Fri, 26 Sep 2014 03:40:13 GMT

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

Re: Geographical Report Creation

jagan — Fri, 26 Sep 2014 03:46:19 GMT

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.

Re: Geographical Report Creation

Fri, 26 Sep 2014 10:38:16 GMT

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