Discussion board where members can get started with Qlik Sense.
I have this scenario:
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?
Go to Solution.
You are using KPI, not a table with some dimension so you would need set expression inside sum to filter rows (1-3)
try something like
rangesum(above(Sum(Sales), Rowno()-3, Rowno()))
Hi Chanty, I tried with my variable name:
But the result is 0
Any other idea?
I understand your point, and I tried with set analisys and work fine using a field (Units_Sale):
But I need to Sum the variable vBudget_Turnover_Moneda :
whit this expression Qlik don't show a result. Maybe is a sintax problem?
Thanks for help
my problem was solve using Set Analisys in my expression, and not rangesum, how Digvijay said.