Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
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.

FISCAL_QUATER_YEAR:

FYQ1 2018-19

FYQ3 2015-16

FYQ4 2015-16

FYQ1 2017-18

FYQ2 2017-18

1 Reply
Champion
Champion

Hi,

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

=PurgeChar(mid(FISCAL_QUATER_YEAR,'6'),'-')

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