1 Reply Latest reply: May 15, 2018 4:53 PM by Jahanzeb Hashmi RSS

    custom fiscal year expression

    Jason Malia

      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]));"####")