Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Departments, their contracts and payments to another departments

Hello!

I`ve got a dimension table called "contracts" which contains information about contracts, its sums and department ID`s that have concluded those contracts.

There`s a fact table called ''turnover", where the transfer sums on that contracts, contract ID`s  and the department ID`s are held. Let`s say, the department "A" has concluded a contract, then there were several payments on a contract to that department, and then a contract has been passed to the department "B", and the rest of sums on a contract were paid to the department "B". How do I link those tables?

Many thanks in advance for your help.

5 Replies
Gysbert_Wassenaar

luciancotea
Specialist
Specialist

links.png

Not applicable
Author

thank you for your advice - I try to make my best to explain the issue

Sorry, I can`t upload anything - all information is "inside the clients`perimeter".

Not applicable
Author

There`s another obstacle - a link table, `cause there is a plenty of various date fields, e.g., contract conclusion date, payment date, etc.

luciancotea
Specialist
Specialist

If you provide incomplete information, you will get incomplete answers.