custom fiscal year expression

[Anonymous]

I am new to qlik, more familiar with BI.

I am trying to create an expression as I would in BI to format a date into a fiscal year as below. The editor tells me formatnumber is not a valid function. Any help on getting me started would be great! thanks

="FY-"+ FormatNumber(If(MonthNumberOfYear([ADT_ARRIVAL_DATE])>=7;Year([ADT_ARRIVAL_DATE])+1;Year([ADT_ARRIVAL_DATE]));"####")

[sasiparupudi1 · Accepted solution]

Try

'FY-' & If(Month([ADT_ARRIVAL_DATE])>=7;Year([ADT_ARRIVAL_DATE])+1,Year([ADT_ARRIVAL_DATE]))

[Anonymous]

thanks!

[zebhashmi]

If(MonthNumberOfYear([ADT_ARRIVAL_DATE])>=7,AddYears(ADT_ARRIVAL_DATE, 1),AddYears(ADT_ARRIVAL_DATE, -1)

Num(number[, format[, dec_sep [, thou_sep]]])