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

[#1]

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

[miguelbraga]

Hey there,

Can you please share your expected output and explain better your issue?

Best regards,

D.A. MB