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

Relationships between data objects

Hi there,

I have a data set like the below.

dataset.PNG

I'd like to figure out how I make a link between TABLE1.TASK DEPENDENCY and the TABLE2.TASKID

I would like to be able to click on 'Task 1' in this table and for it to filter the TASKS table to show only that task. The problem is, they're stored in different tables, with different field name.

Additionally, if the RAG status for TABLE2.TASKID is RED, I'd like to show the cell in the dependencies table as having a red background,

Can anyone help?

6 Replies
settu_periasamy
Master III
Master III

It would be easy if you post some script? Looks like your table is Qualified.

If you want to link between TABLE1.TASK DEPENDENCY and the TABLE2.TASKID,

you need to change one your field name. Then, it will automatically link..

Like

Qualify *;

Unqualify TASKID;

TABLE1:

Load [TASK DEPENDENCY] as TASKID

From Source;

TABLE2:

Load TASKID from Source;



avinashelite

could you please share the sample data of those two tables ?? so that we can suggest a better solution

deepakqlikview_123
Specialist
Specialist

You can simply rename the field

Anonymous
Not applicable
Author

lookup function is used

Not applicable
Author

Hi there

Here is table one. You can see REF is linked to REF in the table 2 (below).

Essentially, IF RAG in table 2 = RED and Status in table 2 = OPEN

THEN the row in table 1 should be highlighted in red

table1.PNG

Here is table 2:

table2 a.PNG

Not applicable
Author

Aha, I have solved this.

The problem was that I was using a table box, not a straight table. Once I had done this, I can add background colour:

=IF([Issue RAG]='RED', lightred(), IF([Issue RAG] = 'AMBER',  yellow(), IF([Issue RAG]='GREEN',LightGreen(),

IF([Risk RAG]='RED', lightred(), IF([Risk RAG] = 'AMBER',  yellow(), IF([Risk RAG]='GREEN',LightGreen(),

IF([Action RAG]='GREEN',LightGreen(), IF([Action RAG]='RED', lightred(), IF([Action RAG] = 'AMBER',  yellow(),white()

)))))))))