5 Replies Latest reply: May 10, 2018 9:44 AM by Jorge Erebitis

# RangeSum result a especific row (no total)

Hi all,

I have this scenario:

Monthrangesum(above( \$(vBudget),0,rowno(total)))
110
220
330
440
......
12120

In my APP I need to show a KPI with the accumulated Budget to specific Month. For Example, Accumulated to March, should show the value 30.

Any one can help me please?

Regards

Jorge

• ###### Re: RangeSum result a especific row (no total)

try something like

rangesum(above(Sum(Sales), Rowno()-3, Rowno()))

• ###### Re: RangeSum result a especific row (no total)

Hi Chanty, I tried with my variable name:

rangesum(above(\$(vBudget_Turnover_Moneda),RowNo()-3,Rowno()))

But the result is 0

Any other idea?

Thx

• ###### Re: RangeSum result a especific row (no total)

You are using KPI, not a table with some dimension so you would need set expression inside sum to filter rows (1-3)

Sum({<Month={">0<3"}>}Budget)

• ###### Re: RangeSum result a especific row (no total)

Hi Digvijay,

I understand your point, and I tried with set analisys and work fine using a field (Units_Sale):

Sum({<OrdenMes={">0<3"}>} Units_sale)

But I need to Sum the variable vBudget_Turnover_Moneda :

Sum({<OrdenMes={">0<3"}>} \$(vBudget_Turnover_Moneda))

whit this expression Qlik don't show a result. Maybe is a sintax problem?

Thanks for help

Jorge

• ###### Re: RangeSum result a especific row (no total)

my problem was solve using Set Analisys in my expression, and not rangesum, how  Digvijay said.

thanks