Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
try something like
rangesum(above(Sum(Sales), Rowno()-3, Rowno()))
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
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)
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
my problem was solve using Set Analisys in my expression, and not rangesum, how Digvijay said.
thanks