Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qlikuser222
Contributor

sum of rows?

Hi ALL,

I have the following requirement and need help.

Can anyone please help to create the fifth column (i.e NewColumn %) in belwo table?

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

Re: sum of rows?

May be like this

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

View solution in original post

6 Replies

Re: sum of rows?

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

qlikuser222
Contributor

Re: sum of rows?

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

Thanks

Re: sum of rows?

How are you getting those values?

qlikuser222
Contributor

Re: sum of rows?

for ID 1 it is  5/10 = 50%

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

Re: sum of rows?

May be like this

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

View solution in original post

aarkay29
Valued Contributor

Re: sum of rows?

In Script:

Load *,

(CumulativeNew/CumulativeTotal)*100  as New%;

Load *,

Rangesum(New,peek(CumulativeNew))  as CumulativeNew,

Rangesum(peek(CumulativeTotal),Total)  as CumulativeTotal

From Table;