topic Re: Next Month Quantity in App Development

Next Month Quantity

Mccullum — Wed, 24 Sep 2025 19:07:40 GMT

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.

Re: Next Month Quantity

robert_mika — Wed, 24 Sep 2025 19:22:28 GMT

Maybe:

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

'MMM YYYY')"}>}QTY)

Re: Next Month Quantity

Mccullum — Wed, 24 Sep 2025 19:36:27 GMT

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

Re: Next Month Quantity

Chanty4u — Thu, 25 Sep 2025 16:51:07 GMT

Try this

Aggr(

Sum(

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

>} QTY

Month

Year

)

Re: Next Month Quantity

Mccullum — Thu, 25 Sep 2025 16:56:12 GMT

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

Re: Next Month Quantity

Mccullum — Thu, 25 Sep 2025 16:57:16 GMT

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

i used this expression this is working as expected.