topic Re: Query by Association of Tables in App Development

Query by Association of Tables

juan_cruz_albornoz — Thu, 06 Jan 2022 19:02:22 GMT

Hello everyone, I am new to the community, it is a pleasure to be in contact.
I'm from Buenos Aires, Argentina. I work in the Qlik department of a company that finances loans to buy cars.

I find the following problem, I have a table called "LoanInstallRow", which contains a field called InstallNr which is the loan installment number. And I have another table called "Payments" that has a field called "Fee Paid".

The question is: How can I link "Fee Paid" with "InstallNr" to verify the payment of the fee.

That is, link both tables to bring the relationship between them.

Thank you very much, I hope I can get some answer. Greetings

Juan Cruz Albornoz

Re: Query by Association of Tables

rwunderlich — Thu, 06 Jan 2022 19:20:36 GMT

There must be some field in the payment table that associates the payment with a loan. What identifies which loan the payment is for?

-Rob

Re: Query by Association of Tables

juan_cruz_albornoz — Thu, 06 Jan 2022 20:48:10 GMT

Thanks!

"Payments" is related to "Loan", by means of the "loan number". And "Loan" is related to "LoanInstallNr" by "MasterID". Is a direct relationship between "Payments" and "LoanInstallRow" necessary?

Greetings

Re: Query by Association of Tables

rwunderlich — Fri, 07 Jan 2022 00:26:03 GMT

A direct relationship is not necessary. You can bring in a third or more tables that create the linkage.