Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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:

Labels (1)
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.