Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Sorting in Pivot table on 2nd dimension

Hi,

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

Regards

1 Solution

Accepted Solutions
MVP
MVP

Re: Re: Re: Sorting in Pivot table on 2nd dimension

See the attached sample.

View solution in original post

5 Replies
Partner
Partner

Re: Sorting in Pivot table on 2nd dimension

hi attach

is your file with the desired sorting

Not applicable

Re: Sorting in Pivot table on 2nd dimension

Hi,

it looks correct but what did u do ?

Thanks

Not applicable

Re: Re: Sorting in Pivot table on 2nd dimension

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

MVP
MVP

Re: Re: Re: Sorting in Pivot table on 2nd dimension

See the attached sample.

View solution in original post

Not applicable

Re: Sorting in Pivot table on 2nd dimension

Hi tresesco,

Thanks for the answer.

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

Regards