Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Sort Pivot Table Dimension Filter

Hi,

In my pivot table, I'm able to sort the Dimension using the Sort panel but it doesn't sort the filter. Can someone guide me on how to do it?

Thanks

Screenshot_3.pngScreenshot_1.png                 Screenshot_2.png  

8 Replies
Highlighted
Partner
Partner

Re: Sort Pivot Table Dimension Filter

Did you use same sorting option in Filter pane?

Highlighted
Contributor
Contributor

Re: Sort Pivot Table Dimension Filter

Yes I did. The dates in the Filter pane is sorted in descending order which is what I want. But the dates in the pivot table's filter is sorted in ascending order.

Highlighted
Master II
Master II

Re: Sort Pivot Table Dimension Filter

Hi,

Try to apply custom sorting as desc in (Filter pane and pivot table ) it should, refer to the attached sample. tks

Capture.JPG

Highlighted
Contributor III
Contributor III

Re: Sort Pivot Table Dimension Filter

Hello,

I have same problem, with more constraints. I want to sort the value field (value column: 2017). I want these number in Descending order. Is it possible?

Captura.PNG

Highlighted
Partner
Partner

Re: Sort Pivot Table Dimension Filter

for all dimensions in pivot chart,

Use Sorting by Expression.

there use Measure of 2017 and choose order as Descending

Highlighted
Contributor III
Contributor III

Re: Sort Pivot Table Dimension Filter

Hello Shraddha,

Thanks a lot, it worked.

Regards,

Sachin

Highlighted
Partner
Partner

Re: Sort Pivot Table Dimension Filter

Please close this thread by marking as Helpful and Correct answer..Qlik Community Tip: Marking Replies as Correct or Helpful

Highlighted
Partner
Partner

Re: Sort Pivot Table Dimension Filter

We have the same problem with sorting in a pivot table.

Sorting for the dimension is set to custom and then to descending for numeric sort. BUT it does not change the order of the items in the filter. Same case with the original question in this thread.

Sorting by expression does not solve our issue. It sorts the table as expected, but not the filter in the pivot table.