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


      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