Sorting in Pivot table - QV

RutiTaumanRubin — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have pivot table with the following coulmns (attached example):

User, Vendor Num , Vendor Name , Date , Oreder Num , Amount

I want to sorting the table by the totals of field amount (expression field) group by User,Vendor Num , Vendor Name , Date.

The field that exists in sort Tab are (attached): Order Num , User , Vendor Num , Date , Vendor Name.

I have tried to insert in sort by Expression :

Aggr(Sum({<Year=>} OrderAmount_$(vCurrency) ) /$(vPrecision) ,User,Vendor Num , Vendor Name , Date)

But it doesn't sorting...

Could you please advise?

Thank you!

Re: Sorting in Pivot table - QV

Sergey_Shuklin — Mon, 08 May 2017 07:29:40 GMT

Hello, Ruti!

The result of "aggr(sum(... " is the set of aggregated fields, in your instance it is values of sum aggregated by specified fields. It can be siutable within dimensions. Nor expressions.

Try to use "sum(aggr(..." or "sum(aggr(sum(...".

topic Sorting in Pivot table - QV in QlikView

Sorting in Pivot table - QV

Re: Sorting in Pivot table - QV