topic Re: Add below Value in QlikView

Add below Value

rohit214 — Tue, 22 Jan 2013 13:33:37 GMT

Hi all,

Sorry for asking silly question but i am not able to get the anwer

Data look Like this i have 2 fields Date and Value and 3rd column shows the the required ouptput.

Date	Value	Required Output
01-01-2013	100	100
02-01-2013	200	300
03-01-2013	300	600
04-01-2013	400	1000
05-01-2013	500	1500
06-01-2013	600	2100

Thanks

rohit

Re: Add below Value

rohit214 — Tue, 22 Jan 2013 13:48:56 GMT

any one.....

Re: Add below Value

nagaiank — Tue, 22 Jan 2013 13:54:02 GMT

In straight table chart, define Date as dimension and Sum(Value) as expression. Check Full Accu,u;ation in the Accumulation box in the properties window Expressions tab to get cumulative (required) value.

Re: Add below Value

rohit214 — Tue, 22 Jan 2013 14:00:41 GMT

hi Sir,

thanks for your answer,

I want that in a field in back end or using expression in front end.

thanks

rohit

Re: Add below Value

Tue, 22 Jan 2013 14:18:56 GMT

Try the below expression..

=Rangesum(above(sum(Value),0,rowno()))

Re: Add below Value

jagan — Tue, 22 Jan 2013 14:21:28 GMT

Hi Rohit,

If you are try this in script then use below script

Test:

LOAD *,

If(RowNo() = 1, Sales, Peek('AccumulatedSales') + Sales) AS AccumulatedSales

INLINE [

Year, Sales

2008, 1000

2009, 2000

2010, 3000

2011, 2000

2012, 3000

2013, 4000

];

Regards,

Jagan.

Re: Add below Value

jagan — Tue, 22 Jan 2013 14:35:31 GMT

Hi Rohit,

PFA file for solution.

Regards,

Jagan.