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: 
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