Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. !
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', ',', ' ') & ' €'
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', ',', ' ') & ' €'