Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
May be this
RangeSum(
Above(
Sum({<[calendar.month] = {02}, [calendar.year] = {2019}, $(p_budget_credit_view), $(p_cy)>} [project_transaction.amount])
, 0, RowNo())
)
Hello @xyz1
There is a special option in object expression tab.
If you need expression with rangesum() you should you rangesum(above(
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?
.
May be this
RangeSum(
Above(
Sum({<[calendar.month] = {02}, [calendar.year] = {2019}, $(p_budget_credit_view), $(p_cy)>} [project_transaction.amount])
, 0, RowNo())
)
.
Would you be able to share a sample and the output you expect to see from it?