Can't link .kml file with excel data in qlik sense desktop

[TobyZ87]

I am trying to link my kml file with an excel spreadsheet to create a heatmap.

The excel field "ONKZ" should be linked with the PTI13ONKZ.Name

When I link them it doesn't link the rest of the data.

[Lisa_P]

I think that the problem is that one field is being loaded as a string and one is loaded as a number, so the values are not matching.  As you load the kml file, format the [PTI13ONKZ.Name] as a number.    num([PTI13ONKZ.Name]) as ONKZ

They should then associate and match values.