topic Sorting problem in QlikView

Sorting problem

k_burata — Mon, 22 Oct 2018 06:04:38 GMT

Hi,

How do I change sorting of dimensions? I would basically to follow the sort order of the Pivot Table Dimensions. So GLE.HOPE should come first since his start date comes first. I know it was correct when I first did it but Plan was relegated to the bottom and I cant manually change the Order.

Regards,

Re: Sorting problem

Anonymous — Mon, 22 Oct 2018 06:24:25 GMT

Hi Burata,

Kindly remove the first two dimension's sort . so chart will sort based on Start dimension

Thanks

Re: Sorting problem

jonathandienst — Mon, 22 Oct 2018 06:30:32 GMT

You can't change the order of the dimensions sorting in a pivot, but you can control how each dimension sorts.

To sort Employee by date, use the expression option for Employee. If the dates are normal numeric date values, then =Start or =(-Start) should be enough.