0 Replies Latest reply: May 27, 2017 2:18 AM by Dilip Solanki RSS

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

    Dilip Solanki

      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