topic Re: Sort pivot table rows by rank and date in QlikView

Sort pivot table rows by rank and date

lindybrits — Wed, 25 Nov 2020 16:16:04 GMT

Hi all!

I would really appreciate help on the following topic.

I have a pivot table that contains the Total Sales and Rank data per year (2014,2015,2016) and month for brands A-J. I was wondering if it would be possible to have two selection boxes - one for Year and the other for Month. If you select for instance 2014, then the table will be sorted according to Rank for Year 2014. On the same note, if you choose for instance Jan, it will sort according to Rank for Month Jan.

According to what I have seen, I cannot choose to sort by expressions in the pivot table.

See below the image. I have also attached sample data as well as the qvd.

This would be of great help!

I am looking forward to hearing from you guys.

Re: Sort pivot table rows by rank and date

lindybrits — Wed, 03 Aug 2016 16:00:12 GMT

I apologise for the misprint - its qvw.

Re: Sort pivot table rows by rank and date

sunny_talwar — Wed, 03 Aug 2016 16:24:50 GMT

Can you check if this is working the way you expect? I can explain what its doing once you confirm

Re: Sort pivot table rows by rank and date

sunny_talwar — Wed, 03 Aug 2016 16:39:10 GMT

You don't have to use the button, I left it there by mistake. Your requirement is to change the sort order based on selection in Month or Year field, right? See if that is working or not

Re: Sort pivot table rows by rank and date

lindybrits — Wed, 03 Aug 2016 16:40:42 GMT

Hi Sunny! On a yearly scale it seems to be working for 2014 and 2015 (rank descending though), for some reason 2016 is not working. When selecting a year as well as a month, it doesn't rank according to that specific month. Selecting only a month doesn't seem to deliver anything specific?

Re: Sort pivot table rows by rank and date

lindybrits — Thu, 04 Aug 2016 10:18:43 GMT

It seems to be working perfectly, on my side, after adding your expression in the sorting tab as well (with brand). Find attached. What might the reason be?

Re: Sort pivot table rows by rank and date

sunny_talwar — Thu, 04 Aug 2016 11:30:23 GMT

So it is working now?

Re: Sort pivot table rows by rank and date

lindybrits — Thu, 04 Aug 2016 11:42:13 GMT

Yes it does. Thanks a lot! I will mark as correct answer. Again, you came to the rescue!

Re: Sort pivot table rows by rank and date

sunny_talwar — Thu, 04 Aug 2016 12:16:44 GMT

Hahahaha, I provided the solution, but was not sure if you needed this or not. But I am glad we did end up getting to the right solution. I like the sorting expression method, but the other one is an alternative as well