topic Re: Expression inside Rangesum in QlikView

Expression inside Rangesum

Saro_2306 — Fri, 15 Nov 2024 23:48:40 GMT

Hi all,

Hope all are doing good, I have small problem in using Rangesum function. My table is like below. I need to perform addition of (A/B) / (D/E) values. I need to show answer as 10 but while using rangesum function it gives output as 2.148

Formula used : =RangeSum(above(SUM(C),0,RowNo())) / RangeSum(ABOVE(SUM(F),0,RowNo()))

Can anybody helps me to perform above calculation. Thanks in advance

A	B	A/B as C	D	E	D/E as C	(A/B) / (D/E)
100	2	50	50	2	25	2
200	5	40	100	10	10	4
300	3	100	200	4	50	2
400	4	100	150	3	50	2

Re: Expression inside Rangesum

MayilVahanan — Wed, 14 Oct 2020 10:25:40 GMT

Try like below

Sum( Aggr(RangeSum(Above(Sum(C)/ Sum(F),0,RowNo())), A))

Screenshot:

Re: Expression inside Rangesum

Saro_2306 — Wed, 14 Oct 2020 10:31:25 GMT

@MayilVahanan Thanks for concern. I need to show sum value is Text box not inside table. your formula works inside table not in Textbox. it shows 26.

Re: Expression inside Rangesum

MayilVahanan — Wed, 14 Oct 2020 10:44:25 GMT

Hi Saro,

If its Text box, try like below

=Sum(Aggr(Above(Sum(C)/ Sum(F),0,RowNo()), A))

Re: Expression inside Rangesum

Saro_2306 — Thu, 15 Oct 2020 11:40:30 GMT

Thanks bro. Its working