2 Replies Latest reply: Aug 16, 2018 4:38 AM by Maurizio Masini RSS

    Qliksense - Sort data in table: put 'others' at bottom, keep numeric value sorting

    Maurizio Masini

      I have a problem in sorting data in a table according to my 'taste'.

       

      The table has names and values and two of the names are 'other' and 'blank'. They both have a value.


      So, if I sort Alpha by name, they can be placed at the bottom using Wildmatch, but then the value order is not respected. If I sort via value, it's obvious they won't be at the bottom.

       

      is there a way to achieve this?

       

      How it is

       

      NameValue
      A100
      B

      120

      C90
      D180
      ---

      30

      Other200

       

      How I'd like it

      NameValue
      D180
      B120
      A100
      C90
      Other200
      ---30

       

      Thanks