Add Backload Field

[#1]

Hay,

I Need to add field to a table who calculate the incremental valua of othe field,

for example i have that table:

Year	Sale
2011	100
2012	200
2013	300
2014	400
2015	500

And i want to make here like that:

Year	Sale	IncremntalField
2011	100	100
2012	200	300
2013	300	600
2014	400	1000
2015	500	1500

Regards Lavi

[sunny_talwar]

Try the following script:

Table:

LOAD *,

  Alt(Peek('IncrementalField'), 0) + Sale as IncrementalField;

LOAD Year,

    Sale

FROM

[https://community.qlik.com/thread/166201]

(html, codepage is 1252, embedded labels, table is @1);

Output in a table box object:

Hope this will help

Best,

Sunny

[#3]

It's work Thank You Very Much.

[sunny_talwar]

No problem

If you got what you were looking for, I would suggest closing this thread by marking the answer as correct.

Best,

Sunny