8 Replies Latest reply: Feb 23, 2013 3:28 PM by whiteline _ RSS

    Splitting comma separated value stored in variable so I can use it is a dimension

    Jeroen Jordaan

      Hello QlikViewers,

       

      I have the following issue.

      I have a comma separated string that is stored in a variable. The string that is stored in the variable looks like this '16', '17a', '18', '19-C', '20', '92'.

       

      I need to find a way that a can split these values so that I can use those values as a dimension.

       

      I tried to use the function SubField but I retrieve only on value and I need them all.

       

      The Straight table or Pivot table I want to create is like this

       

      House No.     Number of Persons

      16                 4

      17a               1

      18                 6

      19-C              2

      20                 3

      92                 4

       

      Thanks in advance