topic AW:Sorting As Per Partial Sums in QlikView

Sorting As Per Partial Sums

Fri, 11 Mar 2011 15:44:14 GMT

Dears,

Good day.

I am having a pivot table with partial sums (columns totals) on the right-side, and I would like to do the sorting of the table on base of those total amounts, is that possible??

Many thanks in advance.

Mauriccio

AW:Sorting As Per Partial Sums

brenner_martina — Fri, 11 Mar 2011 16:07:40 GMT

Hi,

you can enter in the Tab Sort an expression like Sum(Sales) for all dimensions, ASC or DESC

AW:Sorting As Per Partial Sums

Oleg_Troyansky — Fri, 11 Mar 2011 16:19:40 GMT

Hi,

sorting by expression in Pivot Tables is somewhat tricky... The sorting expression is evaluated for each individual Dimension, not for a combination of Dimensions.

For example if pivot table shows Sales by Customer and Product, and both Dimensions are sorted by sum(Sales), descending - the Customers will be sorted based on total Sales by Customer, and the Product will be sorted based on the total Sales by Product (not based on sales of this product for this particular customer). So, the most selling Product overall will always appear first, even if it happens to be #5 for a particular Customer.

just wanted to clarify this point...

AW:Sorting As Per Partial Sums

Fri, 11 Mar 2011 18:31:55 GMT

Dear Oleg,

Actually, it is a very good point, because I tried what Martina suggested (many thanks Martina), however It does not sort descending my customers as per total of sales, in fact, appears a big mess.

Any thoughts??

Mauriccio

AW:Sorting As Per Partial Sums

Oleg_Troyansky — Fri, 11 Mar 2011 19:20:19 GMT

It's hard to guess what you specific problem might be, without seeing your application...

You can try and build a sorting espression using function AGGR() and forcing all the dimensions into the calculation