Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Maps

Hi,

 

I'm not able to plot simple map view.Attached is the sample data.Below is the script.

Tried with both approaches using  Location_Map and using latitude,longitude

Load

GeoMakePoint(latitude, longitude) as Location_Map,
latitude,
longitude

FROM [lib://Source Data files/Country Risk Rating/Crime_Index.xlsx]
(ooxml, embedded labels, table is Armed_Conflict);

 

Please help me with this I'm getting MAD.

 

Thanks..

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

@krish2459 

You must have a unique dimension for each record. Such as a record number, unique site name, unique site location number etc. If you do not have this existing you could create it in the load with a RowNo and place that as the dimension. in your point or bubble layer. Below is your data mapped using RowNo() to create mapping dimension. 

 

Steven_Haught_0-1597072179290.png

 

View solution in original post

3 Replies
Highlighted
Partner
Partner

Have you checked the number formatting when loading the data? Are the numbers correct in the data model?

It would help if you shared how you configured the map object. It may be some issue with the properties usage... 

 

Highlighted
Partner
Partner

@krish2459 Hi, First don't get mad.

Second, your sample data file includes a lot of points per each country, I'm not sure it's valid.

for example:

EliGohar_1-1597064821909.png

I guess you need another dimension per city? Not sure Qlik can digest this kind of data.

In addition, I recommend you to avoid blank rows in excel file and convert the points from text to number:

EliGohar_0-1597065070269.png

 

BTW, for the countries with unique points I got this result:

EliGohar_0-1597064743045.png

Eli.

Highlighted
Creator III
Creator III

@krish2459 

You must have a unique dimension for each record. Such as a record number, unique site name, unique site location number etc. If you do not have this existing you could create it in the load with a RowNo and place that as the dimension. in your point or bubble layer. Below is your data mapped using RowNo() to create mapping dimension. 

 

Steven_Haught_0-1597072179290.png

 

View solution in original post