Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

markusblaut
New 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

Re: Accumulated values

May be this

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

3 Replies

Re: Accumulated values

May be this

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

markusblaut
New Contributor III

Re: Accumulated values

thank you so much!!!

shivanandk
Contributor II

Re: Accumulated values

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

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

Community Browser