2 Replies Latest reply: Sep 21, 2016 2:32 PM by DIEGO PACHECO RSS

    Sorting chars in a string.

    DIEGO PACHECO

      Hi guys,

       

      I´m trying to find a solution to do a sort inside the string, but I´m newbie in Qlik and I don´t know how to solve this problem.

      I´m using Qlikview 12 Personal Edition.

       

      Example: Imagine a table, where exist a field called "Name". Now, I want to create an expression that take every string in the "Name" field and do a sort in it as "Name_Sorted". Please, look at the table below.

       

      NameName_Sorted
      josepejops
      johnhjno
      mariaaaimr
      fedcbaabcdef

       

      Any suggestions on how to do this?

       

      Thank you and sorry for my english.

       

      Diego