Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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]