Rolling 12 expression gives zero

[#1]

Hi Qlik Experts,

I have the following scenario for rolling 12 calculation for which I am getting zero as result. Please help me in identifying the gap in my expression. I have referred many threads and re-aligned my expression , but no luck

I have a qvd with a non-date column which I have converted to date in load script(Refer attached sample app) . I have some other QVDs which have date columns itself for which my rolling 12 expression works fine. So while using similar expression to calculate rolling 12 , I am getting 0 as result. Please help.

-Jamy. !

[sunny_talwar · Accepted solution]

Try these:

=  Num(Sum({<SpendPeriod ={"$(='>' & Date(AddMonths(Max(SpendPeriod), -12), 'YYYYMM') & '<=' & Date(Max(SpendPeriod), 'YYYYMM'))"}>} SpendInvoiceAmount) ,'### ### ### ### ##0,00', ',', ' ') & ' €'

=Num(Sum({< SpendPeriod ={"$(='>' & Date(AddMonths(Max(SpendPeriod), -12), 'YYYYMM') & '<=' & Date(Max(SpendPeriod), 'YYYYMM'))"} >} SpendPOValue) ,'### ### ### ### ##0,00', ',', ' ') & ' €'