Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anabelqlick
Contributor II
Contributor II

Qlik Sense Maps

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!!!

table1.pngtable2.png

 

Labels (1)
  • Maps

1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Anabel

Try AGGR(ONLY(country), country)

Hope it works! Smiley Happy

Regards,

Mauritz

View solution in original post

8 Replies
Channa
Specialist III
Specialist III

can you share ur dimension and measure expressions

may be one place u using distinct

Channa
anabelqlick
Contributor II
Contributor II
Author

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
Specialist III
Specialist III

can you add some sample data those 3 columns

Channa
Channa
Specialist III
Specialist III

in LocationId 

 

try use ONLY(Country)

Channa
anabelqlick
Contributor II
Contributor II
Author

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
Specialist III
Specialist III

try to prepare some sample date and share ur QVF 

Channa
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Anabel

Try AGGR(ONLY(country), country)

Hope it works! Smiley Happy

Regards,

Mauritz

anabelqlick
Contributor II
Contributor II
Author

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

It works!! 😄

map.png