Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to find the nth max fiscal quarter year in a list box using string function?

Hi All,

I have a Fiscal Quarter Year like below loaded in a improper sorting order , How to find the 2nd and 3rd  previous fiscal quarter years and also how to sort the order in the backend script.


FYQ1 2018-19

FYQ3 2015-16

FYQ4 2015-16

FYQ1 2017-18

FYQ2 2017-18

1 Reply


you can use something like this (on the front-end sorting expression) :


on the back-end you can use the same and add an order by ASC at the end of the load