2 Replies Latest reply: Mar 7, 2017 7:14 AM by Sunny Talwar RSS

    Concat numbers in a different way

    Peter Faling

      I am using concat to show all values (and that can generate a long text, which Qlik Sense visually cut in the table by the way. A restriction of 255 characters?)

       

      I use:

       

      concat(Distinct PhotoNo,', ',PhotoNo)

       

       

      Which gives (for example):

       

      PhotoNo

      1, 2, 3, 27, 29, 31, 32, 33, 34, 35, 40, 41, 42, 44

       

       

      But I would like to get a result like this instead:

       

      PhotoNo

      1-3, 27, 29, 31-35, 40-42, 44

       

      Anyway to do that?