Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bryanrichman
New Contributor

Running sum on specific dimensions

Hi all,

I’m trying to create a running sum of issues created over time. As seen below, issues are split by Function (A or B) and Severity (High/Low). I need my running sum to be partitioned by Function and Severity, so at any point I have a count of the issues created in each Function/Severity combination. The table is color coded to show the rows that should be considered together.

Date

Function

Severity

Issues Created

Running Open Issues

1-Jan

A

Low

3

3

1-Jan

A

High

2

2

1-Jan

B

Low

4

4

1-Jan

B

High

1

1

2-Jan

A

Low

1

4

2-Jan

A

High

0

2

2-Jan

B

Low

1

5

2-Jan

B

High

1

2

3-Jan

A

Low

1

5

3-Jan

A

High

3

5

3-Jan

B

Low

0

5

3-Jan

B

High

1

3

I have searched extensively and unfortunately have not been able to get it working.

Primarily, I have tried: Aggr(RangeSum(Above(Sum(Issues Created),0,RowNo())), Function, Severity) , which returns nulls, and

RangeSum(Above(Sum(Total <Function, Severity> Issues Created),0,RowNo(Total)))


Please let me know of any suggestions - thanks for your help!

Bryan

3 Replies

Re: Running sum on specific dimensions

For 2-Jan Why Low as 5?

beck110979
Valued Contributor III

Re: Running sum on specific dimensions

Hi Bryan,

check this:

https://www.youtube.com/watch?v=zIVj4U9QqPQ

i hope that helps

bryanrichman
New Contributor

Re: Running sum on specific dimensions

Hi Anil,

Function = B, Severity = Low had 4 issues on 1/1 and 1 additional on 1/2, so the running sum on 1/2 is 5.