topic Re: Sorting a pivot table in QlikView

Sorting a pivot table

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have a DB table with user / phone call and cost and I'd like to show it in a pivot table sorted by user/cost.

It is possibile to set the Y-order only in the first colums, so the phone cost are sorted correctly, but I lost the user order.

Viceversa, if I set the sort using a formula on the right colums, the user sort is correct, but the cost one is wrong.

In the attached print screen you can see what I mean.

Could anyone help me, pls?

Thanks.

Gysbert_Wassenaar — Mon, 14 Nov 2016 09:57:48 GMT

Perhaps sorting by this expression works: (Max(total Utente) - Utente) * 1000000000 + sum(Costo Traffico)

Anonymous — Mon, 14 Nov 2016 10:36:52 GMT

Thank you for you prompt replay, Gysbert.

To tell u the truth the User field is a string ("1 - Mario Rossi"); I hid the name for privacy reason. I'm sorry if it has driven u on the wrong way.

I can't understand why the solution with the expression Sum(Costo) in the called number column doesn't work correctly: it seems the most logical...

Thanks.