topic Sorting in Pivot table on 2nd dimension in QlikView

Sorting in Pivot table on 2nd dimension

Mon, 14 Oct 2013 07:13:57 GMT

Hi,

Please help on sorting the dimension 'code' in desc order, in the file attached on the basis of sum(Amount)

Regards

lironbaram — Mon, 14 Oct 2013 08:15:08 GMT

hi attach

is your file with the desired sorting

Tue, 15 Oct 2013 15:21:54 GMT

Hi,

it looks correct but what did u do ?

Thanks

Wed, 16 Oct 2013 05:30:56 GMT

Hi,

i see that u just used Sort Desc. on first Dimension, but actually i need to keep the sorting of 1st dim intact,

The scrambled values of dim1 makes it difficult so i'm attaching another file with 1,2,3...etc as dim1 values

Please see attached

Thanks for the help

tresB — Wed, 16 Oct 2013 06:05:27 GMT

See the attached sample.

Thu, 17 Oct 2013 06:03:51 GMT

Hi tresesco,

Thanks for the answer.

Is it possible to achieve this in script, may be using some group by ?

Regards