[Cross Objects] How to refer one calculated column to another one in different table object ?

[#1]

hi, all,

I am new to Qlikview and the following is the issue I faced in recent days.

I have 2 straight table , let's say table A and table B, with 3 columns each called A1, A2, A3, B1,B2,B3.

in my case, A3 is a calculated column, and will be used as B2  (B2=A3).

what expression can I use to refer A3 to B2 , since A3 and B2 are in different object ?

any suggestions?

[#2]

you can use Applymap to achieve the same

go through the below link :

Don't join - use Applymap instead

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

[marcus_sommer]

Inside a chart you could refer to other columns but beyond objects it isn't possible. You will need to use the expression from A3 in the second object again - maybe modified if the structure is different.

- Marcus

[#4]

hi,Marcus,

thsk. it's helpful.