How to use for or for each loop in expression tab?

[#1]

Hi,

I am using Qlik Sense + Geoanalytics, and I have some requirement where I want to iterate some database table records in expression tab.

Use Case

I have geo-analytics bubble layer, where I am plotting pins basis on city name as per below data set. Pins are plotting perfectly. But in Info Bubble window of each pin, I want to display 'all the languages and resources' for selected city.

City	Language	Resources
Mumbai	Hindi	10
Mumbai	English	20
Mumbai	Marathi	30
Chennai	English	20
Delhi	Hindi	20
Delhi	English	30
Gujrat	Hindi	10
Gujrat	English	10
Gujrat	Gujrati	20

e.g. If someone is looking for Mumbai, then he/she should see below layout in Info bubble:

Mumbai

Language     Resources

Hindi          10

English       20

Marathi       30

How can I display this in Info Bubble?

I have above details in one of my database table.

Thanks

[jonas_linden]

Hi Dilip,

First, you need to apply any measure (Location, Size) for the Info Bubble, in order to be able to customize the Bubble layer.

A customization of the Info Bubble can look like this using the Concat function:

'City:'&City&'</br>'&

'Language:'&concat(Language ,',  ')&'</br>'&

'Resources:'&concat(Resources ,',  ')

h