4 Replies Latest reply: Jan 11, 2012 8:10 AM by Aissam Boumejjane RSS

    extracting data using subfield?

    Aissam Boumejjane

      Hi Guys,

       

      I have an order number that has multiple (up to 20) reference numbers.

      I'm trying to extract a field called reference numbers. These numbers are now horizontal displayed. See screenshot.

      refnumber.png

       

      The problem is that I can't select 1 reference number. Instead I have to select 2/3 or more reference number in the reference field.

      If I use the subfield statement I can only select one reference number e.g. Subfield(refnumber, ',', 1) would display the first reference number that's behind a comma that goed the same for subfield(refnumber, ',', 2), I would only get the second ref number .

       

      How can I get all the ref. number vertically so I can select 1 reference number rather than 3 or more?

       

      The other problem is that some ref. numbers are on the left side while others are on the right. Does that mean that qlikview does not recognize them as numbers?

       

       

       

      Hope someone can help!

       

      Thanks!

       

      isam