# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Did you mean:
Contributor III

## 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

1 Solution

Accepted Solutions
Master III

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)

5 Replies
Champion III

try something like

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

Contributor III
Author

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

Master III

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)

Contributor III
Author

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

Contributor III
Author

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

thanks