Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

juanjulian_hs
New Contributor II

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

Re: Fiscal Year calculations

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

satishkurra
Valued Contributor II

Re: Fiscal Year calculations

Agree with Sunny.

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

Khan_Mohammed
Honored Contributor II

Re: Fiscal Year calculations

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?

Community Browser