topic Re: is this sorting possible...within the pivot table in QlikView

is this sorting possible...within the pivot table

RheaQv12 — Wed, 20 Nov 2019 17:38:50 GMT

Hey,

I have this pivot table with few dimensions... one of the dimension values are shown horizontally and there is a sub partial column (Total) - I am trying to get the data sorted by Total values.. i do not care for other dimensions i just want the data to be sorted in descending order based on the sub partial column which is TOTAL

attached some sample data - thanks for any suggestion/ideas

Re: is this sorting possible...within the pivot table

sunny_talwar — Wed, 20 Nov 2019 18:23:23 GMT

Did you try the sorting by y value?

Re: is this sorting possible...within the pivot table

Brett_Bleess — Wed, 04 Dec 2019 19:34:22 GMT

Reha, did Sunny's suggestion work out? If so, do not forget to close the loop on the thread by using the Accept as Solution button on his post to mark it giving him credit for the help and letting other Community Members know it did work for you. If you are still working on things, leave an update on where you are and what you need.

Regards,
Brett