topic Re: Sorting on Pivot Table in QlikView

Sorting on Pivot Table

Anonymous — Wed, 04 Jan 2017 22:07:45 GMT

hello

this is a weird question but how do I sort on a pivot table for a specific dimension

in the example below...

there a dimensions that must be listed 1st/2nd/3rd but I need to sort by the 4th column.. (3fabusage)

I cant move the sort up and down like I could with the other types..

so how do I sort by the 4th columns value but leave it on the 4th column?

thanks

Re: Sorting on Pivot Table

Anonymous — Wed, 04 Jan 2017 23:02:31 GMT

There are some limitations while sorting when it comes to a pivot table. One way of doing this perhaps will be by selection the check box Expression (in the Sort tab) and then in the field, create one expression for your dimension: 3fabusage . Such that it sorts based on the values in 3fabusage

Re: Sorting on Pivot Table

Anonymous — Tue, 10 Jan 2017 00:03:49 GMT

I tried this it doesn't seem to work

I did it for the fabric delivery and its not grouping by the delivery and sorting by that

thanks

Re: Sorting on Pivot Table

johnw — Tue, 10 Jan 2017 00:59:06 GMT

So I gather that your first four dimensions are all 1:1? How about adding a sort expression of 3fabusage to the first dimension?

Re: Sorting on Pivot Table

marcus_sommer — Tue, 10 Jan 2017 06:33:56 GMT

Take a look here: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level).

- Marcus