Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

3 Replies
Not applicable
Author

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

Not applicable
Author

hi,Marcus,

thsk. it's helpful.