Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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