Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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:

Tags (4)
5 Replies
jonas_rezende
Valued Contributor

Re: Sorting pivot table dropdown selection

Hi, Scoot Green.

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

Regards,

Jonas Melo.

Not applicable

Re: Sorting pivot table dropdown selection

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
Valued Contributor

Re: Sorting pivot table dropdown selection

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

Re: Sorting pivot table dropdown selection

Hi Jonas,

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

jonas_rezende
Valued Contributor

Re: Sorting pivot table dropdown selection

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