topic Sorting in a pivot table on 2 dimensions in QlikView

Sorting in a pivot table on 2 dimensions

hopkinsc — Mon, 15 Jan 2024 13:08:33 GMT

Hi all,

I'm struggling to fins a solution to enable me to sort a pivot table correctly using the expression and 1 of the dimensions.

My pivot table has 2 dimension..

Site (as a column) and Month (which has been pivoted).

There is 1 expression.

I want to sort it descending on the expression but for a specific month.

I have attached an example, in the example there are 3 months - Nov, Dec, Jan

I want to sort it using the expression and Dec.

Can anyone help please?

Thanks

Re: Sorting in a pivot table on 2 dimensions

hopkinsc — Tue, 16 Jan 2024 16:18:45 GMT

Does anyone have any ideas on this please?

Re: Sorting in a pivot table on 2 dimensions

Aasir — Tue, 16 Jan 2024 17:36:30 GMT

Use a sorting like below.

if(Month = 'Dec', -YourExpression, 0)

Re: Sorting in a pivot table on 2 dimensions

hopkinsc — Wed, 17 Jan 2024 08:57:23 GMT

Hi, thanks for the reply, I've already tried that but it doesn't work. I can't figure out what the sort it after applying that logic but its not what i need.

The sorting works in the Dec column until values appear in the Nov or Jan column then the sorting in the Dec column stops working.

The values in Dec up until the nulls start are descending, then the 3 values after the 3 nulls are bigger than the values above the nulls, so these 3 values should be before the all of the values in the screenshot.

Could this be a limitation in the pivot table object itself?