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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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...