topic Re: Relationships between data objects in QlikView

Relationships between data objects

Mon, 15 Feb 2016 07:16:32 GMT

Hi there,

I have a data set like the below.

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?

Re: Relationships between data objects

settu_periasamy — Tue, 16 Feb 2016 07:10:32 GMT

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..

Qualify *;

Unqualify TASKID;

TABLE1:

Load [TASK DEPENDENCY] as TASKID

From Source;

TABLE2:

Load TASKID from Source;

Re: Relationships between data objects

avinashelite — Tue, 16 Feb 2016 07:13:13 GMT

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

Re: Relationships between data objects

deepakqlikview_123 — Tue, 16 Feb 2016 07:18:23 GMT

You can simply rename the field

Re: Relationships between data objects

Anonymous — Tue, 16 Feb 2016 07:20:47 GMT

lookup function is used

Re: Relationships between data objects

Wed, 17 Feb 2016 09:08:19 GMT

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

Here is table 2:

Re: Relationships between data objects

Wed, 17 Feb 2016 09:49:55 GMT

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()

)))))))))