Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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 (2)
7 Replies
Creator III
Creator III

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

Contributor II
Contributor II

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.

Creator III
Creator III

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

Capture.PNG

Contributor II
Contributor II

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?

Contributor II
Contributor II

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.

Creator III
Creator III

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

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