Accumulation in Qlik Sense

[#1]

Hi,

Anyone out there who knows how to accumulate a measure in a chart object in Qlik Sense. In QlikView I used to choose "Full accumulation" on the expressions tab, but there's no such feature in Qlik Sense, from what I can see...

Thanks

Pedro

[nico_ilog]

Hi Channing Dionisopoulos,

This video explains it.

How to produce a cumulating bar chart/line chart in Qlik Sense - YouTube

Regards,

Nico

[#3]

Thanks you! It's works.

[munna1317]

Great Work ,

Small Question on Extension to this Question ,

What if we have 2 Expression and 2 Dimension vas well, i am trying using aggr funtion in Qlik Sense it is Not working .

Can you please help me out of this .

I am Trying like this but not working

=Max( Aggr( rangesum( above( Sum(Aggr(sum({<No = {10}>} Expression),Filed-1,Field-2)),0,RowNo())),

Filed-1,Field-2))

Thanks in advance ,

Harish

[#5]

Hi,

What if we want to have all line on the same chart?

Two dimension:

1) Year

2) Fieldname

Two mesures:

--> Sum per fieldname over the year  -> Sum(FieldName)

--> Total sales over the year.   -->  RangeSum(Above(Sum(FieldName),0,rowno()))

But standard line chart only accept one mesure. How can I solve this?

[saniyask]

Hi,

This is working fine.. but what If I am restricting my dimension to say top 5. in this scenario its not giving proper numbers.

Saniya.