topic Re: Current Fiscal Year in QlikView

Current Fiscal Year

Mon, 25 Jan 2016 07:13:41 GMT

HI All,

How to get max of Fiscal year ?

I have data in this format.

2013-14

2014-15

2015-16

Regards,

Keerthi KS

tresB — Mon, 25 Jan 2016 07:16:17 GMT

MaxString(Fiscal_Year) ?

Mon, 25 Jan 2016 07:19:28 GMT

Thanks Tresesco. I was no aware of this function.

jagan — Mon, 25 Jan 2016 07:20:52 GMT

HI,

If you have a date field then try like this

=Only({<DateFieldName = {'$(=Max(DateFieldName)'}>} Fiscal_Year)

MaxString(Fiscal_Year) as Tresesco suggested.

If it is a valid date field then you can directly use

Max(Fiscal_Year)

Regards,

Jagan.

Mon, 25 Jan 2016 07:24:28 GMT

It is derived from datefield.

if(num(month(saledate))<=3,Year(saledate)-1&'-'&right(Year(saledate),2),Year(saledate)&'-'&right(year(saledate)+1,2)) as FiscalYear

saledate is the datefield

tamilarasu — Mon, 25 Jan 2016 07:34:26 GMT

You can also try like below,

Date(Max(Date#(FiscalYear,'YYYY-DD')),'YYYY-DD')