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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Tommmy
Contributor III
Contributor III

RangeSum(Above

Hi experts

The following formula doesn't work or better the syntax is not correct. I need to calculate the value of the last 12 months as sum of the difference between Date1 and Date2:

RangeSum(Above({<[Status]={'Close'}, [Month],0 ,12>})[Date1] -[Date2])

Any ideas?

Thanks, tom

 

Labels (3)
0 Replies