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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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