Qlik Sense Dynamic field name for calculation

[denny_wu]

Hi,

i got problem with my data reloading script.

this is my data.

i want to add new field, that field is (RCCPStartYear + 2) - (RCCPStartYear + 1).

my script right now is like

Load

*,

    [(RCCPStartYear + 2)] - [(RCCPStartYear - 1)] AS Result

Resident OppositeTableGrowingPackFormat;

adds on value (2, 1) is dynamic using qlik variable.

the result should be like:

please help me...

thanks

[jonathandienst]

I dont understand what you are trying to do. The expression

(RCCPStartYear + 2) - (RCCPStartYear + 1)

will always evaluate to 1, and I don't know what you mean by this line

[(RCCPStartYear + 2)] - [(RCCPStartYear - 1)] AS Result|

[denny_wu]

i want do calculation base on RCCPStartYear.
if you see my field name have 2018, 2019, 2020.

so, i want calculate

RCCPStartYear (2018) + 2 = 2020

RCCPStartYear (2018) + 1 = 2019

and get value from field 2020 (1.44914) - 2019 (2.49384) = -1.0447