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: 
xyz1
Creator III
Creator III

?

.

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

May be this

RangeSum(
Above(
Sum({<[calendar.month] = {02}, [calendar.year] = {2019}, $(p_budget_credit_view), $(p_cy)>} [project_transaction.amount])
, 0, RowNo())
)

View solution in original post

6 Replies
mrybalko
Creator II
Creator II

Hello @xyz1 

There is a special option in object expression tab.

cumulative.JPG

If you need expression with rangesum() you should you rangesum(above(

See example

sunny_talwar

What are the expressions behind p_budget_credit_view and p_cy? Also, is this used in a pivot table or a straight table or any other object? Also, is this for QlikView or Qlik Sense?

xyz1
Creator III
Creator III
Author

.

sunny_talwar

May be this

RangeSum(
Above(
Sum({<[calendar.month] = {02}, [calendar.year] = {2019}, $(p_budget_credit_view), $(p_cy)>} [project_transaction.amount])
, 0, RowNo())
)
xyz1
Creator III
Creator III
Author

.

sunny_talwar

Would you be able to share a sample and the output you expect to see from it?