topic Re: How to do Sorting in Pivot table? in QlikView

How to do Sorting in Pivot table?

Wed, 27 May 2015 12:14:11 GMT

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?

Thu, 28 May 2015 04:33:24 GMT

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

Re: How to do Sorting in Pivot table?

Thu, 28 May 2015 05:04:11 GMT

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?

PrashantSangle — Thu, 28 May 2015 05:12:23 GMT

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?

Thu, 28 May 2015 05:18:46 GMT

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?

sujeetsingh — Thu, 28 May 2015 05:23:17 GMT

Use sorting with expression to handle this

Re: How to do Sorting in Pivot table?

Thu, 28 May 2015 05:48:10 GMT

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

Re: How to do Sorting in Pivot table?

Fri, 29 May 2015 07:57:12 GMT

Thanxxx.... alot...

Re: How to do Sorting in Pivot table?

PrashantSangle — Fri, 29 May 2015 09:07:56 GMT

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?

Fri, 29 May 2015 11:03:37 GMT

Yes..