Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
evgeniystuchalk
Contributor II

Accumulation in Pivot Table

Hello. My question on picture:

637e317e98.jpg

1 Solution

Accepted Solutions
laddu_927
Valued Contributor

Re: Accumulation in Pivot Table

Try this with changing underlined values according to your requirement

If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month )  )

8 Replies
OmarBenSalem
Esteemed Contributor

Re: Accumulation in Pivot Table

change your expression as follow:

if(dimensionality()=1, sum(Sales),

if(dimensionality()=2, your expression))

evgeniystuchalk
Contributor II

Re: Accumulation in Pivot Table

thanks. but I need calculate month values also with accumulation

laddu_927
Valued Contributor

Re: Accumulation in Pivot Table

What value you want to display at months.exactly??

evgeniystuchalk
Contributor II

Re: Accumulation in Pivot Table

AcumSales

MonthDimDayDimSalesAcumSales
Apr77
1

1

1
223
347
May512
118
2210
3212
OmarBenSalem
Esteemed Contributor

Re: Accumulation in Pivot Table

Try this:

if(Dimensionality()=1,aggr(rangesum(Above(aggr(Sum(CA),Month),0,RowNo())),Month), rangesum(Above( Sum(CA),0,RowNo())))

Per analogy, I would have:

Capture.PNG

laddu_927
Valued Contributor

Re: Accumulation in Pivot Table

Try this with changing underlined values according to your requirement

If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month )  )

evgeniystuchalk
Contributor II

Re: Accumulation in Pivot Table

Thanks!

laddu_927
Valued Contributor

Re: Accumulation in Pivot Table

Glad it helped you

Community Browser