Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kpteh8888
New 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  

7 Replies
shraddha_g
Honored Contributor III

Re: Sort Pivot Table Dimension Filter

Did you use same sorting option in Filter pane?

kpteh8888
New 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.

devarasu07
Honored Contributor 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

sachinnataraj
New Contributor II

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

shraddha_g
Honored Contributor III

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

sachinnataraj
New Contributor II

Re: Sort Pivot Table Dimension Filter

Hello Shraddha,

Thanks a lot, it worked.

Regards,

Sachin

shraddha_g
Honored Contributor III

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

Community Browser