2 Replies Latest reply: Mar 1, 2018 12:23 AM by Denny Wu RSS

    Qlik Sense Dynamic field name for calculation

    Denny Wu

      Hi,

       

      i got problem with my data reloading script.

      this is my data.

      data.png

      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:

      data.png

       

       

      please help me...

      thanks