topic Re: Refer To An Expression Value Created In Same Load Statement in QlikView

Refer To An Expression Value Created In Same Load Statement

rebelfox — Sun, 12 Jul 2015 10:44:29 GMT

Is there a way I can refer to a column value in a load statement that is itself created in the same load statement?

In other words I build column A from an expression and then in Column B I build a new value which includes the calculated column A value.

This would be the LOAD equivalent of creating a calculated expression column 1 in a straight table chart and then in a subsequent column, refer to the value created in column 1 to create a value in column 2 ( using Column(1) in the expression ).

Thanks

Re: Refer To An Expression Value Created In Same Load Statement

swuehl — Sun, 12 Jul 2015 10:49:58 GMT

Use a precding LOAD:

LOAD *, F4+F3 AS F5;

LOAD *, F1*F2 AS F4;

LOAD * INLINE [

F1, F2, F3

1,2,3

];

Re: Refer To An Expression Value Created In Same Load Statement

sunny_talwar — Sun, 12 Jul 2015 12:23:29 GMT

In addition you can do this two other ways, keeping swuehl‌‌'s example here:

1) Resident Load

Table:

LOAD *, F1*F2 as F4 INLINE [

F1, F2, F3

1,2,3

];

FinalTable:

LOAD *, F4+F3 as F5

Resident Table;

DROP Table Table;

2) In the same load by referring to the actual field names

Table:

LOAD *,

F1*F2 as F4,

(F1*F2) + F3 as F5

INLINE [

F1, F2, F3

1,2,3

];

Best,

Sunny

Re: Refer To An Expression Value Created In Same Load Statement

rebelfox — Thu, 16 Jul 2015 08:38:23 GMT

OK I understand the concept.

Thanks.