RangeSum result a especific row (no total)

[Bukan4x4]

Hi all,

I have this scenario:

Month	rangesum(above( $(vBudget),0,rowno(total)))
1	10
2	20
3	30
4	40
...	...
12	120

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

[Chanty4u]

try something like 

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

[Bukan4x4]

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

[Digvijay_Singh · Accepted solution]

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)

[Bukan4x4]

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

[Bukan4x4]

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

thanks