Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

Labels (4)
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?