Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Baldaia
Contributor II
Contributor II

Point more than 1 location in the map to the same dimention

Good morning; 

I have in my data base multiple zips to the same dimention, like this;

 

Custumer   ShipToZip

XX                123

XX                456

XX                -----

YYY              789

 

If I try to display it in the map, the custumers that have only 1 zip are displayed, but if it has more than 1, the map does't show anything.

 

I want to the map to show me all the Zips linked to the same custumer, in different spots

 

that's the data i'm showing in the map now:

data =[Customer]

Location  =(SHIPTOZIP)&', US'

 

 

Labels (3)
1 Solution

Accepted Solutions
y_grynechko
Creator III
Creator III

Assign dual value to the Customer:

Dual(Customer, ShipToZip) as CustomerLabel

and use CustomerLabel as a dimention on the map. 

View solution in original post

3 Replies
y_grynechko
Creator III
Creator III

Assign dual value to the Customer:

Dual(Customer, ShipToZip) as CustomerLabel

and use CustomerLabel as a dimention on the map. 

View solution in original post

Baldaia
Contributor II
Contributor II
Author

It works! thanks.

 

but now all the values associated to my custumers are duplicated, i'm trying to solve it. thanks anyway

y_grynechko
Creator III
Creator III

the nice way of doing it and not duplicating values is to create additional table.

Create a new table like this: 

CustomerLabel:

Load

Customer,

Dual(Customer, ShipToZip) as CustomerLabel

Resident CustomerTable;

this will allow you to show the labels on the map and shouldn't duplicate the data 🙂