Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

point map problem

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]
2 Replies
sinanozdemir
Specialist III
Specialist III

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

Thanks

Not applicable
Author

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