topic Re: Add resulting list of addresses to bubble label in GeoAnalytics

Add resulting list of addresses to bubble label

Ruthie09 — Wed, 29 Jan 2025 15:35:54 GMT

I've been searching for this answer for 2 days and am stuck.

I have the Geo map with a Geo bubble layer that is plotting the countries for each incident ticket (based on whatever filter options the user selected). A country may have only 1 incident or it might have multiple incidents. What I need is to add the specific Locations and the Issue Type for each resulting country like this (assumes this country had 3 incidents):

Country

Total Incs

Location 1 - Issue Type 1

Location 2 - Issue Type 2

Location 3 - Issue Type 1

etc.

So far, I've only been able to get the first two lines of the expression with no formatting:

=IncCountry & ' ' & count(IncNumber)

So how do I write the expression so it will add a new line for each location, whether there is 1 location or 10 locations (realistically, there will likely be fewer than 5 but I can't say for sure)?

I have no experience with HTML* nor Qlik variables or set expressions, so please walk me through the fix step by step.

Thanking everyone in advance.

* An online tool was able to convert the text above to HTML in case that helps.

Country
Total Incs
Location 1 - Issue Type 1
Location 2 - Issue Type 2
Location 3 - Issue Type 1

Re: Add resulting list of addresses to bubble label

Ruthie09 — Mon, 27 Jul 2020 16:31:41 GMT

Anyone?

Re: Add resulting list of addresses to bubble label

martyginqo — Mon, 27 Jul 2020 16:39:22 GMT

I wouldn't have time to walk through this, but in the past I think I would have used the concat function to aggregate this string. Start with simple concat (field, ',') and build from that.

Martin.

Re: Add resulting list of addresses to bubble label

Steven_Haught — Mon, 10 Aug 2020 21:01:54 GMT

Would it be possible for you to share a sample of your data?

Re: Add resulting list of addresses to bubble label

Ruthie09 — Mon, 10 Aug 2020 21:40:41 GMT

This was the answer. I didn't realize CONCAT was not the same as using ampersands. Thank you, Marty.

This is what I ended up with.

=IF(IncP1P2Flag = 'Yes', IncCountry & chr(10) & 'Total Tickets - ' & count(IncNumber) & chr(10) & (CONCAT(Distinct IncLocation & ' - ' & IncLocationType,chr(10))), IncCountry & chr(10) & count(IncNumber))

Re: Add resulting list of addresses to bubble label

SalvatoreBaker — Fri, 14 Aug 2020 06:01:21 GMT

Your information is very interesting. Thank you for sharing.

Tellpizzahut