topic Re: Null Dimension sorts to the top of my pivot table in QlikView

Pivot table sorting problem

Wed, 13 Aug 2014 20:58:58 GMT

I created a pivot table with the sections created below, however, no matter how I try to sort it, the null section stays on top. How can I get that null section to the bottom of my table? Any insight would be greatly appreciated.

Re: Null Dimension sorts to the top of my pivot table

aveeeeeee7en — Wed, 13 Aug 2014 21:07:48 GMT

Kindly Attach your Application if possible.

Re: Pivot table sorting problem

Wed, 13 Aug 2014 21:25:54 GMT

Hi,

Try selecting Sub Total Field and uncheck all of check boxes in "Sort By" section, repeat this action with Corporate Merch Planning and Quarte Fields, finally order Department by Text value Ascending.

If this doesn't work Order Departments by expression descending and use this:

IF(isnull(Departments),0,1)

IF(Len(Trim(Departments))>0,1,0)

Best regards.