Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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))