topic Re: sorting difficulties in pivot in QlikView

sorting difficulties in pivot

prma7799 — Wed, 02 Sep 2015 12:44:23 GMT

Hi All,

I am facing some sorting issue with pivot table can anyone please help me.

am using dimension

1- cyclic group(DPTB)

=if(aggr(rank((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear),0,4)}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Gross Sales Amount])

-SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear),0,4)}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Return Amount]))/100000),$(=GetCurrentField("DPTB")),Customer)<=$(vTopGRp),Customer,'REST')

3- State

4-month

Re: sorting difficulties in pivot

Wed, 02 Sep 2015 12:53:35 GMT

what is the sort order you are trying to achieve?

Re: sorting difficulties in pivot

sunny_talwar — Wed, 02 Sep 2015 13:40:08 GMT

I am facing some sorting issue with pivot table can anyone please help me.

What exactly is the issue?

Re: sorting difficulties in pivot

ganeshreddy — Wed, 02 Sep 2015 13:55:59 GMT

Hi,

Put you expression in highlighted area for decreasing option.

Re: sorting difficulties in pivot

prma7799 — Thu, 03 Sep 2015 04:05:45 GMT

Hi Sunny,

in my pivot table am unable to get values in sorting order.

for i put in dimension

1- cyclic group DPTB

2- =if(aggr(rank( sum([Sales] )/100000),$(=GetCurrentField("DPTB")),Customer)<=$(vTopGRp),Customer,'REST')

3- State

4-Month

in Expression

SUM ([Sales])/100000

in Sorting Tab

I put above expression as descending order

but sorting is not coming properly

see the attached

Thanks

Re: sorting difficulties in pivot

jonathandienst — Thu, 03 Sep 2015 05:07:13 GMT

Your picture demonstrates the problem, but provides no information that allows diagnosis and accurate suggestions, so I suggest that you post your qvw or a representative sample.

Re: sorting difficulties in pivot

ganeshreddy — Thu, 03 Sep 2015 07:42:30 GMT

Hi qlikview7799,

I am not sure whether i understood your problem right, but try sorting in cyclic group as mentioned below. It may help you to get desired results.

Regards,

Ganesh.