0 Replies Latest reply: Dec 6, 2012 11:34 AM by Mauro Bergamasco RSS

    problem with sort by expression in pivot table

    Mauro Bergamasco

      hello to all,

       

      i am a beginer of qlik and i have a simple question (i think) that I have not found an answer in the community.

       

      given this data

      agcliqtyimp
      AC0011120
      AC0021100
      AC0031130
      AC00401,01
      BC0013500
      CC0061160

       

       

      in a pivot table i want to sort by AG in alphabetical, and then CLI by descending sum(imp)

       

      i cannot find the correct way to do this.

      the problem is the CLI C001 is present ni AGE A and B ..... this situation make incorrect order by expression

      as you can see in the attachment.

       

      can you help me ?

       

      thanks in advance