topic Re: Fiscal Year In text Box in QlikView

Fiscal Year In text Box

upaliwije — Thu, 16 Oct 2014 06:13:25 GMT

I have following List box with Fiscal Years

FYear

2011/2012

2012/2013

2013/2014

and Fmonth list box contain the following

SEP

OCT

NOV

.....

AUG

I have created two list box where I want the text to appear as follows depending on my selection

Text Box 1 Text Box 2

Sep-2011 to Aug-2012 Sep-2012 to Aug-2013 (if I select 2012/2013 as FYear)

Pls help me to write the expression

upaliwije — Thu, 16 Oct 2014 08:36:08 GMT

Will you please help me solve my issue

Anonymous — Thu, 16 Oct 2014 08:42:49 GMT

Quick and dirty:

='Sep-'&LEFT('2011/2012',4)&' to Aug-'&RIGHT('2011/2012',4)

Replace '2011/2012' with e.g. ONLY(FYear).

And of course a LEFT(ONLY(FYear),4)-1 for previous year.

The "problem" is that any selection in Fmonth will NOT impact the text box, but I am not sure if you actually need that.

Kind regards

Niklas

simondachstr — Thu, 16 Oct 2014 08:45:52 GMT

In addition to that:

='Sep-'&LEFT('2011/2012',4)&' to '&Fmonth&'-'&RIGHT('2011/2012',4)

upaliwije — Thu, 16 Oct 2014 10:53:10 GMT

Thanks Both of You