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: 
ali_hijazi
Partner - Master II
Partner - Master II

making an accumulation for a specific interval Help in expression

Hello
I have the following data:

ali_hijazi_0-1684928080948.png
grouped by Month Year
under the first column I have the actual values based on my selection of fiscal year 2023 and thus I have data from 202210 till 202304 (fiscal year starts on October):
Sum({<MonthDiff={0},Scenario={Actual},Date_Num={"<$(=Max({1<[Is Current Month]={1}>}Date_Num))"}>}Periodic)


in the second column I have the previous value next to each current value by month
rangesum(above( Sum( {<[Fiscal Year],[Calendar Year], [Year Month]=, MonthDiff={0},Scenario={Actual}>}Periodic )))


the third column has the difference using the following expression
rangesum
    (
        Sum({<MonthDiff={0},Scenario={Actual},Date_Num={"<$(=Max({1<[Is Current Month]={1}>}Date_Num))"}>}Periodic),
        -1*above( Sum( {<[Fiscal Year],[Calendar Year], [Year Month]=, MonthDiff={0},Scenario={Actual}>}Periodic )
))

Now what I want is make an accumulation starting from 202210 till 202304

182 then 182 + 27, 182+27+4 , etc...
I tried to add an additional rangesum on top but I'm getting accumulation from the very start
kindly advise

 

I can walk on water when it freezes
Labels (1)
0 Replies