Use calculated Dimension in the same LOAD

[Dennis_Aguilar]

I am new in QlikView. Yet I have experience in R using the tidyverse library.

I have this code

temp_B:

LOAD

     dimension_1,

     dimension_2,

     dimension_1 + dimension_2 as dimension_3,

     dimension _1 * dimension_3

RESIDENT temp_A;

The problem arises when I try to use dimension_3  to multiply dimension_1. 

I have seen other codes where people usually do this:

      dimension _1 *(dimension _1  + dimension _2)

However, when calculations are too big I would rather use my way.

How do I achieve this?

[sunny_talwar · Accepted solution]

Do it in a preceding load

temp_B:
LOAD *,
     dimension _1 * dimension_3;
LOAD
     dimension_1,
     dimension_2,
     dimension_1 + dimension_2 as dimension_3
RESIDENT temp_A;

[Dennis_Aguilar]

THANK YOU!

[Shubham_Deshmukh]

Mark it as a correct ans please