topic Re: Sort Date Dimension in Pivot Table in QlikView

Sort Date Dimension in Pivot Table

joshabbott — Wed, 18 Mar 2015 19:24:53 GMT

I'm trying to sort by date in a pivot table that will be 'pivoted'. There are two dimensions that I'm using, Letter, and Date. I want the dates over the top to be sorted over the sorted letters:

Example:

1/1/2015 2/10/2015 etc

I know I've had problems with this in the past, and am just 'stuck'. Thank you for any help, example attached.

Re: Sort Date Dimension in Pivot Table

Anonymous — Wed, 18 Mar 2015 19:32:53 GMT

I'm not sure I understand the problem... Try to sort Letter by text and Date by number.

Re: Sort Date Dimension in Pivot Table

joshabbott — Wed, 18 Mar 2015 19:39:25 GMT

I did, and unfortunately, that didn't work. I want on the left for it to be sorted by 'Letter' and on pivot over top of the pivot table, it to be sorted by date:

Re: Sort Date Dimension in Pivot Table

Wed, 18 Mar 2015 19:53:48 GMT

Sort the date by Numeric Value and Letter by Text.

Re: Sort Date Dimension in Pivot Table

Anonymous — Wed, 18 Mar 2015 20:06:12 GMT

It works for me - see attached. Or I don't understand what you need...

Re: Sort Date Dimension in Pivot Table

joshabbott — Thu, 19 Mar 2015 12:09:37 GMT

You're right, I thought I'd tried that. Thank you!