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):
Location 1 - Issue Type 1
Location 2 - Issue Type 2
Location 3 - Issue Type 1
So far, I've only been able to get the first two lines of the expression with no formatting:
=IncCountry & '<br>' & 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.