Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

QS How to add accumulated line ?

Hi All

I have a chart , which display yearly amount , i like to another line , which display the accoumulation amount.

Hope some one can help me.

In my example i have :-

+19.8

-11.7

-20

+30.8

So i wish the Accumulated amount by year will end with total amount = 20 K as shown in the left table.

In my next post i will enclosed with QS QVF file.

1 Solution

Accepted Solutions
MVP
MVP

Re: QS How to add accumulated line ?

Try as second expression

=Rangesum(Above(Sum({<ExecPLStart={"176"}>}Amount/1*-1)/1000,0,rowno()))

And I don't think you need a sample file with >7 MB and 35 sheets to demonstrate your issue.

3 Replies
paulyeo11
Valued Contributor II

Re: QS How to add accumulated line ?

Enclosed my QS QVF sample file .

Pls refer to last sheet of my Sample chart.

MVP
MVP

Re: QS How to add accumulated line ?

Try as second expression

=Rangesum(Above(Sum({<ExecPLStart={"176"}>}Amount/1*-1)/1000,0,rowno()))

And I don't think you need a sample file with >7 MB and 35 sheets to demonstrate your issue.

paulyeo11
Valued Contributor II

Re: QS How to add accumulated line ?

Hi Swuehl

Many thank your expression as usual work fine.

I am sorry. I will further reduce the data.

Paul

Community Browser