Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fiscal Year calculations

Hello all,

I am trying to obtain the Year to Date set analysis code to be able to calculate the revenue continuously during a Fiscal Year. I have the current data calculated on my excel and it is written in this format:

(=IF(R$4=S$4,R69+S35,S35))

(=IF(Fiscal Years equal, Add the previous month's revenue to the current month's revenue, if not add only the current month revenue)

In this way I make sure that at beginning of the financial year (April) no data is carried on from previous months.

So far in Qliksense I have developed the following set analysis:

Sum({<Date=,[Fiscal YearMonth]={"<=$(=$(=vMaxFiscalYearMonth))>=$(=$(=vMinFiscalYear))"}>}[Act+Fcst Data])/1000000

However, this formula doesn't identify a change in Fiscal Years.

I hope someone knows how to code this properly

3 Replies
sunny_talwar

Would you be able to provide some data with the expected output from it to clarify what you mean?

satishkurra
Specialist II
Specialist II

Agree with Sunny.

Also can you try by selecting YearMonth filter to see if any data populates?

MK9885
Master II
Master II

No data should be selected for Jan, Feb and Mar?

And if 2017 is selected the sum should only add from Apr of 2017 till Dec 2017 and not from Apr 2016 to Apr 2017?