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

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.

Tags (1)
5 Replies

Re: cardinality issue

luciancotea
Valued Contributor

Re: cardinality issue

links.png

Not applicable

Re: cardinality issue

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

Re: cardinality issue

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
Valued Contributor

Re: cardinality issue

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

Community Browser