topic Re: Calculation between two Resident Tables in QlikView

Calculation between two Resident Tables

Fri, 11 Apr 2014 14:36:41 GMT

I have the following script and I want to do the calculations over fields loaded from two resident tables

(example : B*Y/C*Z as 'W') and keep in Level1 table. How it could be possible ?

Level1:

Load A, B , C
Resident P

left join (Level1)

Load C, Y, Z
Resident Q;

Re: Calculation between two Resident Tables

maxgro — Fri, 11 Apr 2014 14:41:33 GMT

Level1:

Load A, B , C
Resident P
left join (Level1)
Load C, Y, Z
Resident Q;

Final:

noconcatenate load

A, B, C, Y, Z,

B*Y/C*Z as W

resident

Level1;

drop tableLevel1;

or I'm missing something?

Re: Calculation between two Resident Tables

MK_QSL — Fri, 11 Apr 2014 14:43:38 GMT

may be like this...

M1:

Mapping Load * Inline

[

C, Y,

30, 40

];

M2:

Mapping Load * Inline

[

C, Z,

30, 50

];

T1:

Load

B*ApplyMap('M1',C)/C*ApplyMap('M2',C) as W

Inline

[

A, B, C

10, 20, 30

];

Re: Calculation between two Resident Tables

MK_QSL — Fri, 11 Apr 2014 14:45:15 GMT

M1:

Mapping Load * Inline

[

C, Y,

30, 40

];

M2:

Mapping Load * Inline

[

C, Z,

30, 50

];

T1:

Load * Inline

[

A, B, C

10, 20, 30

];

NoConcatenate

Final:

Load

B*ApplyMap('M1',C)/C*ApplyMap('M2',C) as W

Resident T1;

Drop Table T1;

Re: Calculation between two Resident Tables

Fri, 11 Apr 2014 14:54:07 GMT

Thank you very much ! It helped !