Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik4asif
Creator III
Creator III

Issue in set analysis expression - Rolling 12 Months

Hello guys ,

could you please help me in solving the below expressions.

Sum({<Datum = {">=$(=MonthStart(AddMonths(Max(Datum),-9))) <=$(=Monthend(AddMonths(Max(Datum),2)))"}>}Belege_Qty_Ordered)

above expression is not working, it is working for only current expression.

not working for Rolling 12 Months

 

 

Labels (2)
1 Reply
Chanty4u
MVP
MVP

can you try this?

=SUM({<   DateNum = {">=$(=Date(MonthStart(Today(),-11),'MMM-YY'))<=$(=Date(MonthStart(Today()),'MMM-YY'))"}

  >}Belege_Qty_Ordered)

or

rangesum(above(sum(Belege_Qty_Ordered),0,12))