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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumlated Fiscal start to current month Set Analysis

hi .

I am trying to create an accumulated value.

I have a fiscal year 2013/2014.

Start Month is May.

I wish to select the fiscal year i.e 2013/2014 and Month Jul and return the values between May - Jul    for 2013/2014.

i have the following statement but it is not working currently.

Any help greatly appreciated.

Sum(

        {$< FYear={"$(=Dual(Max(fYear)-1 & '/' & Max(fYear), Max(fYear)))"}>}

            FMonth={"<=$(==Max( {<fYear={$(=Max(Year))}>} Month))"}   

>

Sum(Amount)

Best

Brad

Labels (1)
0 Replies