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
rabbani_sk
New 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

Tags (1)
1 Reply
YoussefBelloum
Esteemed Contributor

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

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