9 Replies Latest reply: May 29, 2015 7:03 AM by Ashish Pawar

# How to do Sorting in Pivot table?

Hello,

I am new in qlikview, can any one tell me how to do sorting in pivot table,for following scenario

I wanted to sort the prd group of each division in descending order of there total ytd value...

• ###### Re: How to do Sorting in Pivot table?

Hello Friends, Can any one give me solutions of this - - -....?

• ###### Re: How to do Sorting in Pivot table?

Hi,

I don't think you can do sorting in Pivot table, it's kind of limitation in this. Still attach your app, let me find some work around.

Regards,

Navdeep

• ###### Re: How to do Sorting in Pivot table?

Hi,

Chart->property->sort->select dimension Product Group->sort->Expression->write expression of total ytd value

and select descending.

Regards

• ###### Re: How to do Sorting in Pivot table?

Thanxxx.... alot...

• ###### Re: How to do Sorting in Pivot table?

Welcome..

Did you get required result??

If yes then close thread, If not then let me know.

Regards

• ###### Re: How to do Sorting in Pivot table?

Yes..

• ###### Re: How to do Sorting in Pivot table?

Hu Pawar,

sorting in Pivot table is possible only based on the dimensions and it can be done only through chart properties>Sort window alone.

You can sort using expression ....

Ramya.

• ###### Re: How to do Sorting in Pivot table?

Use sorting with expression to handle this

• ###### Re: How to do Sorting in Pivot table?

Hi Sujeetsingh,

We can sort using Expression in pivot table,

try like this:---

=Rank(aggr(Expr to be sort,all dimensions))

Example: Rank(Aggr(Sum(Sales),Year,Quarter,Month)) here Sum(Sales) is the expression to be sorted and year,Quarter,month are the dimensions used in pivot table