Add new filed in table A by referring one filed fr... - Qlik Community

Report Inappropriate Content · ‎2017-02-01

Hi guys,

I am a beginner of Qlikview and stucking at this issue for two days.

I have two tables T5 and T6 and they are linked by KEY1 as below:

I would like to add one field at T6 based on below condition:

Count(DISTINCT if((T6_ope_no<=T5_ope_no)*(T5_ope_no<=T6_TST_ope_no), T5_ope_no,if(T6_ope_no=T6_TST_ope_no,0)))

Its working fine in straight table but I would like to add this new field in T6 table when I load data.

I cannot do any JOIN because if I join two table, it would be very huge data and it slows down my QV.

Is there way that I could add new field in T6 based on above condition in loading script?

sunny_talwar · ‎2017-02-01

You can look into ApplyMap or Lookup function

Add new filed in table A by referring one filed from table B