Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anabelqlick
New 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)
1 Solution

Accepted Solutions
Mauritz_SA
Contributor III

Re: Qlik Sense Maps

Hi Anabel

Try AGGR(ONLY(country), country)

Hope it works! :smileyhappy:

Regards,

Mauritz

8 Replies
Channa
Valued Contributor III

Re: Qlik Sense Maps

can you share ur dimension and measure expressions

may be one place u using distinct

Channa
anabelqlick
New Contributor II

Re: Qlik Sense Maps

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
Valued Contributor III

Re: Qlik Sense Maps

can you add some sample data those 3 columns

Channa
Channa
Valued Contributor III

Re: Qlik Sense Maps

in LocationId 

 

try use ONLY(Country)

Channa
Highlighted
anabelqlick
New Contributor II

Re: Qlik Sense Maps

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
Valued Contributor III

Re: Qlik Sense Maps

try to prepare some sample date and share ur QVF 

Channa
Mauritz_SA
Contributor III

Re: Qlik Sense Maps

Hi Anabel

Try AGGR(ONLY(country), country)

Hope it works! :smileyhappy:

Regards,

Mauritz

anabelqlick
New Contributor II

Re: Qlik Sense Maps

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

It works!! 😄

map.png