topic Re: Use calculated Dimension in the same LOAD in QlikView

Use calculated Dimension in the same LOAD

Dennis_Aguilar — Sat, 16 Nov 2024 04:20:18 GMT

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?

Re: Use calculated Dimension in the same LOAD

sunny_talwar — Tue, 26 Feb 2019 17:30:54 GMT

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;

Re: Use calculated Dimension in the same LOAD

Dennis_Aguilar — Tue, 26 Feb 2019 17:52:24 GMT

THANK YOU!

Re: Use calculated Dimension in the same LOAD

Shubham_Deshmukh — Wed, 27 Feb 2019 06:40:00 GMT

Mark it as a correct ans please