Qlik Sense Maps

[anabelqlick]

Hi guys!

I need help with maps, please.

I'm showing values of a table in a map. This is ok when all values are distinct, but it doesn't work when I have any repeated value.

I add images for better comprenhension.

The values in the first table are correctly situated in the map. However, in the second table, map only shows unique values, i don't know why.

Sorry for my basic English.

Thanks!!!

[Channa]

can you share ur dimension and measure expressions

may be one place u using distinct

[anabelqlick]

Hi Channa! 

I have an area layer with country, and two point layers, showing according to selection in the table, like this:

=If(GetSelectedCount([Año_Glo]) = 1 and GetSelectedCount([Año_Sec])= 0, Posicion_Tot)

=If(GetSelectedCount([Año_Sec]) = 1 and GetSelectedCount([Año_Glo])= 0, Posicion_Sec)

I  have tried to use "distinct", but i don't know how.

Thanks a lot.

[Channa]

can you add some sample data those 3 columns

[Channa]

in LocationId 

try use ONLY(Country)

[anabelqlick]

I haved tried Only(country), but same result 😞

I don't have any elaborate measure, I just write my field name to show Channa. The data are in the table in the images on my message.

Thanks a lot

[Channa]

try to prepare some sample date and share ur QVF 

[Mauritz_SA · Accepted solution]

Hi Anabel

Try AGGR(ONLY(country), country)

Hope it works!

Regards,

Mauritz

[anabelqlick]

Thank you so so so much Mauritz!!!! 😄 😄 😄

It works!! 😄