Pages and Levels - Sorting

[ShaneMichelon1]

Hi!  I have a requirement to generate a report with Excel sheets for a set of months.  This works fine but how do I show the most recent month as the first worksheet?

[JonnyPoole · Accepted solution]

I added a "negative" month number to the data model and 'paged' on the month number to make the highest month number value  (and most recent) month appear first. 

I noticed you can't use the <Month> table tag (otherwise it repeats of course) so I created a new expression to place at the top of each page to display the month

When running the template in PDF mode, the pages come in ascending order based on the negative month number which means highest (most recent) month first

Please note this older post provided the solution which is still valid in Tabular Reports  https://community.qlik.com/t5/Qlik-NPrinting/How-to-sort-the-way-Pages-appears/td-p/1269550

[ShaneMichelon1]

Thanks and sorry for the delay in replying.  I didn't realize someone had replied.  The only issue with that technique is that the sheet names will be numeric instead of the text I want (ie I want to see Jan 23, Feb 23, Mar 23, etc).