topic How to Sort a Pivot Table by the automatic Qlikview SubTotal in QlikView

How to Sort a Pivot Table by the automatic Qlikview SubTotal

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm new in the community and also a new Qlikview user.

I have already looked at several posts here in the community but I couldn't find out exactly what I was looking for.

I have created this pivot table:

it has 6 dimensions, but I am going to show only 3: Country, Year and Week n° (which is a calculated dimension =week(Document_Date))

I have only 1 expression, represented by the count - distinct of the document of each country.

I have added the automatic subtotal as shown, and now I need to sort the Country by the column Total.

The week N° is also sorted by Value number.

I think I have to use "sort by expression" in the sort table, but I did so many tries with no result.

Can someone please help me?

Thank you so much.

Davide

sunny_talwar — Thu, 28 Jul 2016 19:28:02 GMT

Have you tried sorting by y value on the sort tab?

Thu, 28 Jul 2016 20:00:48 GMT

‌Hi Sunny, thanks for your replay!

Actually yes, but it didn't work, and on the other hand I lost the sort by value applied to the Week N dimensions.

Thanks a lot anyway.

Regards.

Davide