Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

edp
New Contributor III

Sorting a pivot table

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.

N.

2 Replies

Re: Sorting a pivot table

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

edp
New Contributor III

Re: Sorting a pivot table

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.

N.