Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
I Need to refer to this post , i bring to top.
Are you looking any help on this?
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.
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