Rolling up Next two months in qlik sense

[eddywong71]

Hi All,

May I ask how to sum rolling up Next two Months Data. The Latest Data Month and Join Month is 202305.

Dimension : [Join Month]

I am using expression :

RangeSum(Above( total Sum([Amount]) , 0, 1) ) 

The expression result same as Sum([Amount])

How can i revise the expression to get above highlighted result.

[eddywong71]

Any one can help ?

[Chanty4u]

try this 

RangeSum(
Above(Total Sum({< [Join Month] = {">=$(=Max([Join Month]))<=$(=Max([Join Month])+2)"} >} [Amount]),
0,1))

[eddywong71]

Hi Chanty4u,

Base on your expression.

RangeSum(
Above(Total Sum({< [Join Month] = {">=$(=Max([Join Month]))<=$(=Max([Join Month])+2)"} >} [Amount]),
0,1))

The result like below

However, i would like below