topic Add Backload Field in QlikView

Add Backload Field

Sun, 31 May 2015 15:04:10 GMT

Hay,

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

for example i have that table:

And i want to make here like that:

Regards Lavi

sunny_talwar — Mon, 01 Jun 2015 12:27:10 GMT

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

Mon, 01 Jun 2015 12:36:51 GMT

It's work Thank You Very Much.

sunny_talwar — Mon, 01 Jun 2015 12:39:27 GMT

No problem

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

Best,

Sunny