Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have sales table and debt table , in order for me to figure out individual customer sales amount vs debt amount , i am sure i need to make use of field = cust_id from both table to create a link key.
if the answer is correct. then i like to ask again :-
since my sales table consist of 4 country sales. so in order to create a link key , i need to make use of :-
filed = cust_id and field = SOURCE combine to get the link key.
Paul
Hi Paul,
I saw your questions in Qlikcommunity. I think knowledge about Linktable will be helpfull for you. If two or more common fields exist between 2 fact tables you are recomomed to creat linktable. Because if you don't do this circle or synfield will appear like this :
after create a linktable, you can avoid syntable:
The attachment i tried to create a linktable. You can search Qlikcommunity to find some detail introduce to linktable.
Regards,
zhou
Hi Paul,
Can you attach some sample of both tables with all the columns?
Regards,
Jagan.
Hi Jagan
Thank you for your sharing.
Enclosed my QV sample file.
Hi Paul,
I saw your questions in Qlikcommunity. I think knowledge about Linktable will be helpfull for you. If two or more common fields exist between 2 fact tables you are recomomed to creat linktable. Because if you don't do this circle or synfield will appear like this :
after create a linktable, you can avoid syntable:
The attachment i tried to create a linktable. You can search Qlikcommunity to find some detail introduce to linktable.
Regards,
zhou
Hi Paul,
I think you are joining the tables with the wrong key because of this the tables are not joining properly, no single value is matching in both the tables. In Sales table your key values are 1-254 and Debit values are from 255-322. Check this with your team regarding the Key column between the two tables.
Hope this helps you.
Regards,
Jagan.
Hi Zhou
You are another one like chowdary who is very good link table. this is the skill which is very impt to make table look neat. by the way my skill still need about 2 year to be able to like you to create the table i wish and link them as i like.
Paul
Hi Jagan
I am using the cust_id field to link sales and debt table :-
(1) from Payment Table.
AutoNumberHash128(@1:9T,'TDSS') As LINK_KEY_DEBT,
@1:9T as [CUST_ID_PAY],
(2) from sales Table.
autoNumberHash128(@1:10T,'TDSID') As LINK_KEY_DEBT, |
@1:10T as [cust_id], |
This is what i need , so that i can know particular customer , how much their contribution and their outstanding debt.
Paul