topic Re: Sorting pivot table in QlikView

Sorting pivot table

rohitians — Fri, 08 Mar 2013 11:25:34 GMT

I have a pivot table to analyze sales with previous year i want to sort in desc order according to the expression i.e sales but it is not getting sorted ....

Re: Sorting pivot table

sushil353 — Fri, 08 Mar 2013 11:32:16 GMT

in the sort tab select the dimension to sort and then put the same expression in the sort by expression.

HTH

Sushil

Re: Sorting pivot table

Gabriel — Fri, 08 Mar 2013 12:18:03 GMT

Hi,

To sort in order of your preference follow steps below

right click on the chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type

=Match(DIMENSION NAME,’xxx’,'xxxx','xxxx') (xxx stands for name of the order say you have JAMES, MARTIN e.t.c) Don’t forget to enclose each in single quotation mart (‘).

Click ok.

let me know if this is helpful or solve you problem.

Regards,

Gabriel

Re: Sorting pivot table

VishalWaghole — Fri, 08 Mar 2013 12:47:20 GMT

Hi,

In sort tab select dimension on which you want to apply sort expression.

Then go to expression box and put your logic in below expression.

IF(Dimension = '0-12', '1',

IF(Dimension = '12-24', '2',

IF(Dimension = '24-48', '3',

IF(Dimension = '48-72', '4',

IF(Dimension = '> 72', '5')))))

Thanks and Regards,

Vishal Waghole.