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
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
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);
Hi All
Enclosed my sample QV Doc , hope some one can advise ?