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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
narayanaqlik
Creator
Creator

Rolling sum of last 12 months and by default it should select current year of last 12 months data

If(GetSelectedCount(OrderDate)<0,RangeSum(Above(Count({<OrderDate={">=$(=MonthStart(Today(),-12))<=$(MonthStart(Today()))"}>}OrderID)),0,RowNo())),

RangeSum(Above(Count({<OrderDate={">=$(=AddMonths(MonthStart(Max(OrederDate)),-12)<=$(=MonthStart(Max(OrderDate)))"}>})))

)

Kindly Help in this here my Problem is if i am not selecting any date it should be selected current year rolling sum other wise selected year rolling 

but her it is not working it is displaying max year as cumulative values and rest it is showing all zeros even i am not selecting any year , 

 

if i am selecting particular then it is working fine but i want by default it should select from current month to last 12 months from current year

 

0 Replies