Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

how to calculation total % after sum() in straight table


Hi guys

there is a table like this

a   b     c

1   100  1000

2   200   2500

3   300   3000

...

and then, i need to get a table like this

a   b    c         d

1  100  1000   0.1(100/1000)

2  300   3500  0.085(300/3500)

3....

...

i used the straight table ,in the expression

b and c column, i used  full accumulation,

but i can not get d column with correct data.

i used / in d Column.

but it will get this data as below:

1 100 1000 0.1 (100/1000)

2 300 3500 0.08 (200/2500)

so how can i get the correct data.

Please help me ,thanks very much!!

1 Reply
MVP & Luminary
MVP & Luminary

Re: how to calculation total % after sum() in straight table

Try rangesum(above(sum(b),0, RowNo()))/rangesum(above(sum(c),0, RowNo()))

See attached qvw.


talk is cheap, supply exceeds demand
Community Browser