Range Sum - can't get my expression to work

zagzebski — Sat, 19 Sep 2015 15:33:55 GMT

THis should be simple but obviously doing something wrong. I want Expression 2 to accumulate on expression 1 - it should look like "What I want" column but all it is doing is returning the same number for the current row.

Expression 1: SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL])

Expression 2: RangeSum(Above(SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL]),0,RowNo()))

Month/Year	Expression 1	Expression 2 (not working as expected)	What I want
Jan-15	4,500.00	4,500.00	4,500.00
Feb-15	4,500.00	4,500.00	9,000.00
Mar-15	24,568.81	24,568.81	33,568.81
Apr-15	4,500.00	4,500.00	38,068.81
May-15	4,500.00	4,500.00	42,568.81
Jun-15	1,991.79	1,991.79	44,560.60
Jul-15	-	-	44,560.60
Aug-15	-	-	44,560.60

Zag

Re: Range Sum - can't get my expression to work

marcus_sommer — Sat, 19 Sep 2015 16:18:29 GMT

Try:

RangeSum(Above(SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL]),0,RowNo(TOTAL)))

- Marcus

Re: Range Sum - can't get my expression to work

MK_QSL — Sat, 19 Sep 2015 16:24:09 GMT

Check enclosed file..

Re: Range Sum - can't get my expression to work

evan_kurowski — Sat, 19 Sep 2015 16:26:29 GMT

And don't forget if your chart is a straight table, that you have the 'Accumulation' options.

topic Re: Range Sum - can't get my expression to work in QlikView

Range Sum - can't get my expression to work

Re: Range Sum - can't get my expression to work

Re: Range Sum - can't get my expression to work

Re: Range Sum - can't get my expression to work