topic Re: column-above(column) in QlikView

column-above(column)

OmarBenSalem — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

here is what I have achieved with the above function

what I want instead is having the sum of all the values above not only the final value.

For example; for Qhour 8:300, I want to return the sum of 23011+8434+4992+742+165, not onlu 23011+8434

How to do so?

Thank you

Kushal_Chawda — Tue, 29 Mar 2016 08:04:02 GMT

=rangesum(above(sum(YourField),0,rowno()))

MayilVahanan — Tue, 29 Mar 2016 08:07:20 GMT

Try like this

=Rangesum(Above(Sum(Sales),0, RowNo()))

MK_QSL — Tue, 29 Mar 2016 08:11:27 GMT

RangeSum(Above(YourExpression),0,RowNo()))

RangeSum(TOTAL Above(YourExpression),0,RowNo()))

OmarBenSalem — Tue, 29 Mar 2016 08:38:35 GMT

Yes, that went all good !

Thank you all