Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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