1 Reply Latest reply: Oct 12, 2016 12:45 PM by Miguel Braga RSS

    Sorting on two fields, first field ascending, second field descending.

    Nitin Jadhav

      Hi,

      I am new to qlik sense, and not sure how to apply sort order in pivot table on two field

       

      EmpTyp(char),    Overtime(number)

       

      I want to sort first on EmpTyp in ascending order and then on sum of ot descending order.

       

      can some one give me expression syntax for this.

       

      Secondly, if pivot table - 'appearance' is set to 'Indent Rows', how to resize 'Rows' so that all my 'Columns' will fit on the screen.

       

      regards, Nitin