after create link table for my data model , all my target table not able link to master calendar

[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

Then suddenly i notice that all those sales target table amount and date does not work now.

The table script as below :-

Concatenate

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          ODSE as ODSE,

          visit_tar_amt as visit_tar_amt,

          actual_visit as actual_visit

FROM QSNP_2009.xls (biff, embedded labels, table is [visit_tar_09$]);

link table is not able link the above date , because when i select any year , all the visit_tar_amt is dis-selected.

Any one can advise me ?

Paul

[paulyeo11]

My main issue is the link table only link the below sales table , due not link those concatenance table (target table), how to force the link_supply_key also link with my target table data ?

sales:

LOAD left(FileBaseName(), 4) AS Report_dod_1,

          'TDSS' as Source_Sales,

          'TDSS' as SOURCE,

          @1:10T as [cust_id],  

          year(@50:60T) as [SalesDate],

          year(@50:60T) as [date],

          if(@241:248T = '2',@134:147T*-1,@134:147T) as [sales],

          left(@11:42T,31) as [company],

          @313:343T as [desc],

          AutoNumberHash128(@50:60T,'TDSS') As Link_Supply_Key

FROM Q_FCCC09.txt (ansi, fix, no labels, header is 0, record is line);

[paulyeo11]

Hi All

Enclosed my sample QV Doc , hope some one can advise ?