Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting pivot table dropdown selection

I have a pivot table with a dropdown selector for year and quarter.  Is there any way to change the sort to be descending by year and quarter?

It's based on a drilldown dimension:

5 Replies
jonas_rezende
Specialist
Specialist

Hi, Scoot Green.

The fields year and quarter are as dimension in pivot table?

Regards,

Jonas Melo.

Not applicable
Author

Hi Jonas, sorry I didn't get back to you right away; but I was on vacation.

Yes the Year and Quarter are dimensions in the pivot table.

jonas_rezende
Specialist
Specialist

Hi, Scott Green.

In Desktop version, follow the steps below:

  1. Menu Settings, Groups tab;
  2. Choose the group desired and click button Edit;
  3. Click in button Sort Orders;
  4. Change the classification of your field.

Hope this helps!

Not applicable
Author

Hi Jonas,

Thanks for the input; but I'm running the Enterprise Server version.

jonas_rezende
Specialist
Specialist

No problem. Make the change in the file .qvw, then deploy it on the server.