After I add Link Table script , My Target Exp amount not link to year

[paulyeo11]

Hi All

I have a QV doc which is working fine for 3 year , last week i learn from forum Mr Kar i am able to make use of link table , so that my SOURCE field is link to all my sales supplier GL table, it work fine.

http://community.qlik.com/message/360418#360418

After add the link table , Then suddenly i notice that all those Exp target table amount and date does not link to year.

This is because the SOURCE field for Exp target table is not link to link table.

Hope some one can advise me.

Enclosed my QV Doc

Paul

[#2 · Accepted solution]

Hi Paul,

Find attachment with corrected script..

I found few mistakes on your script.

Go thorugh the attachment,If you have any doubt you can contact..

Hope its helps you

Karthik

[paulyeo11]

Hi Kar

I like your approach very much. Today i learn some new thing how to aviod sync key on date by create a unique date table. Otherwise my major mistake is i must addthe link from my target table , so that my target date can ltink o sales date.

Thank you vey much.

Paul

[paulyeo11]

I Need to refer to this post , i bring to top.

[#5]

Are you looking any help on this?

[paulyeo11]

Hi Kar

I still looking at your sample which is working fine. Now my issue is I start my data model with GL table and I add sales table okay . Add link table okay and when I add supplier table I get stuck . Let me figure out . Thank you for your concern.

[paulyeo11]

Hi Kar

http://community.qlik.com/message/370221#370221

Can you pls help me check the way i create link table it is correct ? if correct , may i know how to remove the $sync key ?

Paul