Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Modelling issue - Circular Reference

Hi guys,

I'm kind of stuck with the tables I'm modelling for a small Qlik Sense application. Maybe there's a way to keep things simple and I'm not seeing it.

I have a table of "Corridors" and "Signals" belonging to the corridor. Note that one signal can belong to more than one corridor:

LOAD * INLINE [
SignalCode,CorridorID
7026001,1
7026001,2
7026002,1
etc.

And I have another table where I define the "approach link" to the Signals, with a column that tells the direction:

Approaches:
LOAD * INLINE [
SignalCode, Approach_Dir, link.id
7026001,'E',70752504
7026001,'W',70752004
7026002,'E',70752503
7026002,'W',70752005
];

Now my problem is that I have some links that are not an approach to any Signal, but that belong to the corridors. If I try to do something like below, I create a circular reference:

Corridor_Links:
//Links that belong to each corridor and are not approaches
LOAD * INLINE [
CorridorID, link.id
1,70752006
];

Do you know of any "clean" way to model this tables? What would you recommend?

Thanks much

1 Reply
Highlighted
Digital Support
Digital Support

How about joining this tables?

Check this Help Page with some Join information please: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.