Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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