topic Re: After I add Link Table script , My Target Exp amount not link to year in QlikView

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

paulyeo11 — Sun, 30 Jun 2013 06:56:32 GMT

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

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

Mon, 01 Jul 2013 05:11:23 GMT

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

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

paulyeo11 — Mon, 01 Jul 2013 05:35:48 GMT

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

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

paulyeo11 — Fri, 19 Jul 2013 05:48:04 GMT

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

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

Fri, 19 Jul 2013 08:25:05 GMT

Are you looking any help on this?

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

paulyeo11 — Fri, 19 Jul 2013 09:45:57 GMT

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.

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

paulyeo11 — Sun, 21 Jul 2013 07:19:13 GMT

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