5 Replies Latest reply: Apr 9, 2015 7:51 AM by Jonathan Dienst RSS

    concat function: concatenate ALL values

    Dror Svartzman

      Dear Qlikview warriors,

       

      This should be easy

       

      I'm trying to create a comma separated list of all Score in the table, regardless of if they are filled or not

       

      Name Score
      Dan
      Debra50
      Dror
      Fabian
      John70

       

      Only Debra and John showed the courtesy to attend the test.still i want to have a list containing all scores of the class

       

      requested result should be: ,50,,70

       

      tried the following formula with no luck

       

      =concat(TOTAL Score, ',', Name)
      

       

      also attached example