topic Re: sorting issue in pivot table. in QlikView

sorting issue in pivot table.

kishorj1982 — Mon, 11 Sep 2017 08:45:28 GMT

Team,

could you please suggest how to sort the values in descending order as per value in total column.

thanks,

Re: sorting issue in pivot table.

shraddha_g — Mon, 11 Sep 2017 08:47:41 GMT

Sort by Expression,

Put Expression for Total in Expression box and put descending order

Re: sorting issue in pivot table.

Anil_Babu_Samineni — Mon, 11 Sep 2017 08:49:50 GMT

Chck this

Re: sorting issue in pivot table.

kishorj1982 — Mon, 11 Sep 2017 09:11:50 GMT

Hi,

But in your file month are not in order from most recent month to least recent month.

Regards

Re: sorting issue in pivot table.

Kushal_Chawda — Mon, 11 Sep 2017 11:30:30 GMT

use below in Sort ->Expression

=sum(aggr(pick(Match([Not Paid in Last],'3 months','6 months','9 months','1 Year','> 1 Year'),Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -2), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver), Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -5), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver), Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -8), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver), Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver), Sum({<AR_CustomerLedger.MonthYear ={"*"}-{">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver) ),AR_CustomerLedger.MonthYear,AR_CustomerLedger.CustomerName))

Re: sorting issue in pivot table.

karthikoffi27se — Mon, 11 Sep 2017 13:00:15 GMT

Hi Kishore

Use =Match ([Not Paid in Last],,'3 months','6 months','9 months','1 Year','>1 Year)

That will sort according to the field.

Many Thanks

Karthik