Qlik sense Calculated Field using Previously Loaded Tables

[mMelia]

Hello, I'm new to Qlik Sense. 
I have two tables Facts and Calendar. They both have same field Date. 
I want to get new calculated Field which uses one field from Facts table and one from Calendar. 
If I use join I get Circular reference. 

Is it okay to leave circular reference and if not how can I avoid it?

[MayilVahanan]

HI 

Try like below

Remove / Rename Year2 from "a" table. Because, its already join with Fact table via S_Y and Fact is join with Calendar. So you can fetch Year2 info from Calendar not required in "a".

[mMelia]

Hi, Thanks for quick replay.
If I try to remove calendar table join Year2 is not visible in Table a.


How can I fetch field from joined table? 

[MayilVahanan]

Once all logic is done, you can remove the field 

Or, you can rename Year2 as "a_Year2", so that it can't cause any issue