Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
IGLE
Contributor
Contributor

Map not recognizing single ISO Code

Hi All,

I have KPI that results in the following ISO Country Code 'MDV' for  Maldives.

The KPI is the latest new country with an order, as below:

=FirstSortedValue(distinct [Country ISO],-aggr(min(if([Orders]>0,[Date],0)),[Country ISO]))

If I put it on a KPI view, no problem, yields 'MDV'.

If I write on a map view as dimension ='MDV', no problem, maps shows Maldives.

But... if I write the formula that yields 'MDV' on the map dimension, it doesn't work. It says "The data contains invalid geometries that could not me shown on the map.".

I don't understand how is it possible that writing the result 'MDV' works, but writing the formula that yields 'MDV' doesn't. Can anyone help?

Thanks a lot!

Labels (2)
0 Replies