Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasadmundewadi
New Contributor III

Using RangeSum??

This is my table

load * inline

[A, B

P,1

Q,2

R,3

S,4

T,5

U,6

V,7

W,8

X,9

Y,10

Z,11];

I want to show a result like this in a table:

  

A            BSum(below(B))
P165
Q263
R360
S456
T551
U645
V738
W830
X921
Y1011
Z110

the 3rd column is derived like this:

e.g.

for P (2+3+4....+11)

for Q (3+4+5...+11) etc.

How can I do this?

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Using RangeSum??

Try this

=Sum(TOTAL B) - RangeSum(Above(TOTAL B, 1, RowNo(TOTAL)))


Capture.PNG

1 Reply
MVP
MVP

Re: Using RangeSum??

Try this

=Sum(TOTAL B) - RangeSum(Above(TOTAL B, 1, RowNo(TOTAL)))


Capture.PNG