Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Fiscal year to date

 
 
 
 

 


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]

 
This expression is always giving me 0 in chart
 
 
 
 
1 Reply
Kushal_Chawda

@Qlikuser09  try YeartoDate function

 LOAD [Work Date], 
      YearToDate([Work Date],0,10)*-1 AS [Fiscal Year-to-Date]