Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kiwi_qlik
Contributor II
Contributor II

Getting rid of circular reference.

Hello,

I have been stuck on trying to find a solution to attached circular reference. I would be eternelly thankful if anyone could help.

I cannot just get rid of connection between 'statystyki_ogloszen' and 'firmy' tables, because there are more values for ID_Oferty in 'statystyki_ogloszen' than in 'historia_aplikacji' and therefore I would lose a proper connection between ID_Firmy and ID_Oferty.

I have tried to figure out some link tables solution, but it just does not add up in this case for me.

The root of the problem can be shortened to the following:

1) statystyki_ogloszen
- ID_Oferty
- Nazwa_Firmy

2) firmy
- ID_Firmy
- Nazwa_Firmy

3) rekruterzy
- ID_Firmy
- ID_Rekrutera

4) historia_aplikacji
- ID_Oferty
- ID_Rekrutera

So as you can see, there are 4 dimensions, each one is in 2 different tables, which altogether makes a crappy circular reference.

Labels (3)
7 Replies
NitinK7
Specialist
Specialist

Hi,

 do you need "ID_Rekrutera" field in  historia_aplikacji table because this field  already used in rekruterzy table ,

4) historia_aplikacji
- ID_Oferty
- ID_Rekrutera  //comment this field

kiwi_qlik
Contributor II
Contributor II
Author

Yes, I definitely need it. 'historia_aplikacji' is a table with history of changes made by recruiters on particular applications for particular job offers. There can be multiple recruiters changing the same application, so I need to know exactly who made the change.

NitinK7
Specialist
Specialist

check below highlighted field and comment any one based on your data

Capture.PNG

kiwi_qlik
Contributor II
Contributor II
Author

I'm sorry, I don't think I get what you're saying now.

Do you want me to put "//" in source code next to ID_Rekrutera? Cause I can't do that, it is an essential field in the data model.

EDIT:
The photo didn't load when I wrote this comment.

But still, even now - do you want me to describe what "Nazwa_Firmy" means and why is it in given tables?

kiwi_qlik
Contributor II
Contributor II
Author

Let me put it this way:

'firmy' means "companies". The table contains basic information about companies
It is linked to:
-> 'rekruterzy' (recruiters), by ID_Firmy (company_id). This table shows which recruiters belong to which companies.
-> 'statysytki_ogloszen' (offers_statistics), by Nazwa_Firmy (company_name). This table shows a list of job offers, offered by given companies + their basic results.

The 'historia_aplikacji' (application_history) table shows changes that have been made historically on applications for job offers. It has to show the ID_Oferty (offer_id) and ID_Rekrutera (recruiter_id), because I need to know who is making changes on which application for which offer. Thus, it is also linked with 'statysytki_ogloszen' (offers_statistics) and 'rekruterzy' (recruiters), which creates the loop.

NitinK7
Specialist
Specialist

I think without looking data it is very difficult to find out solution 

mark_costa
Partner
Partner

Hi,

We just released a new video in our YouTube channel related to your question.
I hope it helps!

IPC Tips - Removing Circular References
https://youtu.be/s-QA8fbQDC4

 

Regards,

Mark Costa