# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Contributor

## sum of rows?

Hi ALL,

I have the following requirement and need help.

ID  Total  New  Old    New/Total %       NewColumn % i.e (New(5+8)/Total(10+20))

1      10     5         5       50%                        50%

2       20    8         12      40%                  43.3%

3        0     0          0        0                          43.3%

4        0      0         0       0                            43.4%

Thanks

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: sum of rows?

May be like this

RangeSum(Above(NewExpression, 0, RowNo()))/RangeSum(Above(TotalExpression, 0, RowNo()))

6 Replies
MVP

## Re: sum of rows?

Not sure how you getting 43.3% and 43.4% for ID 3 and 4, resp.

Contributor

## Re: sum of rows?

Sorry its a typo its 43.3% fro ID 3 and 4 respectively.

Thanks

MVP

## Re: sum of rows?

How are you getting those values?

Contributor

## Re: sum of rows?

for ID 1 it is  5/10 = 50%

for ID 2 it is  (8+5)/20+10) = 43%

Highlighted
MVP

## Re: sum of rows?

May be like this

RangeSum(Above(NewExpression, 0, RowNo()))/RangeSum(Above(TotalExpression, 0, RowNo()))

Valued Contributor

In Script: