Full accumulation

[syukyo_zhu]

I’m looking for a way to accumulate a measure in a chart object in Qlik Sense. In QlikView I can choose "Full accumulation" on the expressions tab, but it seems there's no such feature in Qlik Sense. I have checked about it in this forum. It seems “Full accumulation” not yet included. I should use rangsum(above ……)

So I want to know if it’s always true?

[syukyo_zhu]

Perhaps, you are right.

I finded other way to do it, thanks for your proposal.

[sunny_talwar]

You found another way to do it? Would you be able to share this with us? Would love to know how else can this be done?

Best,

Sunny

[syukyo_zhu]

yes

i used set analysis in my expression

if(sum({<month={5,6,7,8}>}amout)>0,aggr( rangesum(above(total Sum({<month={5,6,7,8}>}amout),0,RowNo())),year,(month,(numeric))))

and then disable option "show zero value" in the chart's propertise

finaly i get this

[sunny_talwar]

Great, thanks for sharing this with us

Best,

Sunny