Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Bukan4x4
Contributor III
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
Digvijay_Singh
Master III
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)

View solution in original post

5 Replies
Chanty4u
Champion III
Champion III

try something like 

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

Bukan4x4
Contributor III
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

Digvijay_Singh
Master III
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)

View solution in original post

Bukan4x4
Contributor III
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

Bukan4x4
Contributor III
Contributor III
Author

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

thanks