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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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
MVP
MVP

@Qlikuser09  try YeartoDate function

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