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

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

rabbani_sk — Tue, 15 May 2018 18:42:29 GMT

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

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

YoussefBelloum — Tue, 15 May 2018 22:52:27 GMT

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