Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.