Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Connecting tables and avoiding circular reference

Hi All i need help with the following;
i am putting together two source systems thorugh the following logic.
i aim to derive a unique customer price for each timecode connected a relative artno which in turn is connected to a project number, with a specific customer attached to that project.
Table 1: PriceList - (Unique Customer Table that is linked to individual pricing scheme through use of an article number) - DB1
Table 2 links to the transactional table.  (see db model pic attached for logic description)
CustomerNrartnrpris(price)
1501020
1400030
2501040
Table 2: TimeCode - Table that connects to the transactional table and tells it which artno is been used in the project. - DB2
TimeCodeIdtidkodartno
20consulting5010
35running4000
40snoozing3000
any modelling tips on how to create this relationship without running into circualr refernce and recieving the right price to the right project project number?
//best
Bradley
Community Browser