point map problem

Mon, 06 Jul 2015 17:40:28 GMT

When I load points they all appear incorrectly; data appears to be loading correctly;

using load script

Unqualify *;

CustomerAccounts:

load *,

GeoMakePoint(Latitude,Longitude) as GeoKey;

load

AccountFacts.AccountReportingLevel0 as Theater,

AccountFacts.AccountReportingLevel1 as Region,

AccountFacts.AccountReportingLevel2 as Region_Sub1,

AccountFacts.AccountReportingLevel3 as Region_Sub2,

SFAccountId,

ApplyMap('HasCapacityOppty',SFAccountId,'No') as HasCapLikeOpenOppty,

AccountFacts.AccountName as AccountName,

AccountFacts.AccountType,

AccountFacts.AccountStatus,

AccountFacts.AccountOwnerName as AccountOwner,

AccountFacts.CountryTheater,

AccountFacts.BillingStreet,

AccountFacts.BillingCity,

AccountFacts.BillingState,

AccountFacts.BillingPostalCode,

AccountFacts.Country,

AccountFacts.CountryISO3166Alpha3,

AccountFacts.CountryGroup,

AccountFacts.CountryGroup_PAC,

AccountFacts.IsEmergingCountryGroup,

AccountFacts.EmployeeSegment,

AccountFacts.VerticalSegment,

AccountFacts.Industry,

AccountFacts.SIC,

AccountFacts.IndustryDescription,

AccountFacts.NumberOfEmployees,

AccountFacts.Longitude as Longitude,

AccountFacts.Latitude as Latitude,

Example of point on incorrect map?

Using the Maps Chart Object - Points Maps - Part 1 - (video)‌

[-71.281088999999994,41.945084999999999]

Re: point map problem

sinanozdemir — Mon, 06 Jul 2015 20:26:26 GMT

Can you please attach only your lat & long data if it is not confidential?

Thanks

Re: point map problem

Mon, 06 Jul 2015 21:44:54 GMT

sorry it is confidential.. example of data is the [] above.

topic point map problem in QlikView

point map problem

Re: point map problem

Re: point map problem