Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
HereWeGoAgain
Contributor III
Contributor III

Year to Date Trend line

Good Day all

Please assist with following:

I would like to create a trendline chart. using Revenue and per month.

Our fiscal year start in July and Ends in June.

Is there also a possibility that I can compare it to previous fiscal years?

Thanks in Advance

1 Reply
Dalton_Ruer
Support
Support

Typically this is done by creating "flags" for the values when loading the data in. Within the Qlikkie community you will find a lot of posts about something called a Master Calendar. 

For this specific need, refer to the InYearToDate function and notice that you can tell the function which is the first month of your fiscal year. 

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...