7 Replies Latest reply: Oct 3, 2013 7:37 AM by Ridhaa Hendricks RSS

    Delimit data

    Ridhaa Hendricks

      Hi All

       

      I have a result set with the below reason code sting, I would like to delimit the data based on the >> how can i do this in qlikview?

       

       

      |Reason code                               |   Date           |  Agent    |

      | Shop1>>Help Desk>>Enquiry|  2013-10-01 |      John   |       

       

      I would like to the delimit the reason code column like below

       

      |Reason code 1|  |Reason Code 2  | | Reason Code 3|

      |        Shop1        |         Help Desk      | |            Enquiry  |

       

      The data is based on a SQl result set

       

      Regards,

      Ridhaa