Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunnydear7
Contributor
Contributor

Qlik Sense Map Chart Label Expressions

I have a Map Chart with a Point Layer showing different GDCs as dimension. There are already expressions in the label(Options -> General -> Labels) which display a calculated value for each GDC(dimension ) Value.

eg.

[=
gdc_name &chr(10) &
If(GetFieldSelections(Homepagev)='Data',num(sum({<Type={'Received'},month_year={"$(=monthname( max(month_year)))"},gdc_name=,[Customer Name]=>}Values)/sum({<Type={'Expected'},month_year={"$(=monthname( max(month_year)))"},gdc_name=,[Customer Name]=>}Values),'##.##%'),'')

]

The above expression shows % of Data received for each GDC eg value (100%)

-----------------------------------

I want to include an expression here  which can display different values of a field "LOS" for each corresponding GDC. 

GDCLOS
AL1
AL3
BL2
CL1
CL2
CL3

 

So displayed in the Map, i would like something like the following

100%

L1, L3  

 

B

100%

L2

 

C

100%

L1, L2, L3

 

for each GDC bubble in the Map Chart correspondingly.

Please advise if this can be done or if there is a another way to do this.

 

1 Reply
Steven_Haught
Creator III
Creator III

@sunnydear7 

You could try adding this to the end of your expression:

&chr(10) &concat(distinct LOS, ',')