Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Set vFiscalYearStartMonth = 10;
LOAD [Work Date],
If( Month(Date([Work Date])) >= $(vFiscalYearStartMonth) AND Year(Date([Work Date])) = Year(Today()), 1, 0 )
AS [Fiscal Year-to-Date]
@Qlikuser09 try YeartoDate function
LOAD [Work Date],
YearToDate([Work Date],0,10)*-1 AS [Fiscal Year-to-Date]