topic Re: Sorting in Pivot Table in QlikView

Sorting in Pivot Table

MK_QSL — Wed, 20 Nov 2013 15:19:02 GMT

Can we sort below this pivot table by

SUM(Sales) for each CustomerName?

Re: Sorting in Pivot Table

Josh_Good — Wed, 20 Nov 2013 15:53:28 GMT

Yes. Since CustomerID is unique to CustomerName you also need to sort CustomerID by Sum(Sales)

Re: Sorting in Pivot Table

MK_QSL — Wed, 20 Nov 2013 16:14:53 GMT

actually I need SUM(Sales) to be sorted descending order. Means,,,,,

Customer ID should be ID001, ID002, ID003....etc

and SUM(Sales) should be descending order....

Re: Re: Sorting in Pivot Table

Josh_Good — Wed, 20 Nov 2013 17:27:24 GMT

Sort Brand by Sum(Sales) in descending order.

Re: Sorting in Pivot Table

Mon, 24 Apr 2017 18:45:12 GMT

Your problem is that you are using a field that contains the same name for all customerName and you have to crear other field creating an unit key for all records or display the customer name as unic column.

You can tu use the customerID&':'&CustomerName to display the code and name together. see qlikview example.

The problem is that qlikview is identifying field named Brand as iqual records. For examplo B1 is tha same in all records.

I hope help you.

Re: Sorting in Pivot Table

Mon, 24 Apr 2017 18:51:58 GMT

Here you are the best solution.

I'm sure it works correctly