how to find max fiscal year?

[balasundaram]

YearName(TempDate, 0, $(vFiscalYearStartMonth)) AS FiscalYear,

above expression giving 2013-2014,2014-2015

Year(FiscalYear) as FiscalYearNum;

above expression giving 2013,2014

my concern is both are same selections are not....

i need to get max fiscal year in barchart i written set exoression like

=Count({<FiscalYearNum= {"$(=Max(FiscalYearNum))"}>}[Type]) it is working

but if i written like

=Count({<FiscalYear= {"$(=Max(FiscalYear))"}>}[Type]) it is not working

tell me how can you write setexpression by using FiscalYear filed?

[ecolomer]

You can consult this:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

Try this:

=Count({<Num(FiscalYear)= {"$(=Max(Num(FiscalYear)))"}>}[Type])

[israrkhan]

I Think you need to use Dual() function in load script, to create a number for each fiscal year..

see dual function here

Qlik Tips: Using Dual