Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erebitis
New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

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)

5 Replies
Chanty4u
Esteemed Contributor III

Re: RangeSum result a especific row (no total)

try something like 

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

erebitis
New Contributor II

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

Digvijay_Singh
Honored Contributor III

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)

erebitis
New Contributor II

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

erebitis
New Contributor II

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

Community Browser