How to do Sorting in Pivot table?

[#1]

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...

[#2]

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

[#3]

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

[PrashantSangle · Accepted solution]

Hi,

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

and select descending.

Regards

[#5]

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.

[sujeetsingh]

Use sorting with expression to handle this

[#7]

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

[#8]

Thanxxx.... alot...

[PrashantSangle]

Welcome..

Did you get required result??

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

Regards

[#10]

Yes..