topic Re: sum of rows? in QlikView

sum of rows?

qlikuser222 — Thu, 23 Mar 2017 19:01:35 GMT

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

sunny_talwar — Thu, 23 Mar 2017 19:08:57 GMT

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

qlikuser222 — Thu, 23 Mar 2017 19:12:45 GMT

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

Thanks

sunny_talwar — Thu, 23 Mar 2017 19:14:37 GMT

How are you getting those values?

qlikuser222 — Thu, 23 Mar 2017 19:18:23 GMT

for ID 1 it is 5/10 = 50%

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

sunny_talwar — Thu, 23 Mar 2017 19:25:53 GMT

May be like this

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

aarkay29 — Thu, 23 Mar 2017 19:37:40 GMT

In Script:

Load *,

(CumulativeNew/CumulativeTotal)*100 as New%;

Load *,

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

Rangesum(peek(CumulativeTotal),Total) as CumulativeTotal

From Table;