Qlik Community

New to Qlik Sense

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

CityLanguageResources
MumbaiHindi10
MumbaiEnglish20
MumbaiMarathi30
ChennaiEnglish20
DelhiHindi20
DelhiEnglish30
GujratHindi10
GujratEnglish10
GujratGujrati20

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

1 Reply
jonas_linden
Partner - Contributor
Partner - Contributor

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 ,',  ')

India_Concat.pngh