Next Month Quantity

[Mccullum]

Create a Qlik Cloud measure that displays the next month’s Sum(QTY) for each current MonthYear row.
It must respect all other dashboard filters and selections.
The solution should not rely on sort order or functions like Above/Previous.
Values must update dynamically when dimensions or filters change.

[robert_mika]

Maybe:

Sum({<MonthYear = {"=Date(MonthStart(AddMonths(MonthStart(MonthYear), 1)),

'MMM YYYY')"}>}QTY)

[Mccullum]

In a table with many rows (Jan-23 → Sep-25), this will likely evaluate once globally, not row-by-row. So all rows could get the same value or null

[Chanty4u]

Try this 

Aggr(

    Sum(

        {<

            MonthYear = {"=$(Date(AddMonths(MonthStart(Only(MonthYear)),1),'MMM-YYYY'))"}

        >} QTY

    ),

    Month

Year

)

[Mccullum]

I tried this method this is also didn't work.

[Mccullum · Accepted solution]

Aggr(Above(Sum(QTY),1),(Month _Year,(Numeric, DESCENDING))).

i used this expression this is working as expected.