Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?