Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markusblaut
Contributor III
Contributor III

Accumulated values

Dear fellows,

I would like to calculate a KPI.

Example:

I would like to sum up the budget as far as actual sales exist.

There are actual Sales for the month Jan.-April.

So the calculation would be:

100+50+100+25 = 275

Unfortunately my formula does not work:

If( [Actual Sales] > 0,

(rangesum(above(sum([Budget]),0,RowNo())))

,0)

Many thanks for any support!!

Best,

Markus

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(Aggr(If(Sum(Sales) > 0, Sum(Budget)), Month))

View solution in original post

3 Replies
sunny_talwar

May be this

Sum(Aggr(If(Sum(Sales) > 0, Sum(Budget)), Month))

markusblaut
Contributor III
Contributor III
Author

thank you so much!!!

shivanandk
Partner - Creator II
Partner - Creator II

Instead of using AGGR function, the Set Analysis should will be better

Sum( {$ <[Month]={"=Sum([Actual Sales])>0"} >} Budget)