Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

simontouyet
New Contributor

How to check if another table has a record that meet a certain criteria?

Hi all,

I have 2 tables, one with events and one with tasks.

Tasks:

Load

[Task ID],

[Event ID],

    Date

Inline

[

    Task ID, Event ID, Date

    1, c, 24/03/2016

    2, a, 06/06/2016

    3, e, 01/12/2016

    4, b, 01/01/2015

    5, f, 02/08/2016

    6, a, 02/02/2017

];

Events:

Load

[Event ID],

    Date

Inline

[

  Event ID, Date

  a, 01/01/2017

  b, 01/01/2017

  c, 01/01/2017

  d, 01/01/2017

];

What I would like is: while I am loading the Events table, can I have a calculated field where it checks if the Tasks table contains an item that has the same Event ID and a date older than the data in the event table?

So basically, when the events table is loading its first row, it should ask itself "Is there a task with an [Event ID] = 'a' with a Date < 01/01/2017 ?" and should return "Yes".

When the Events table loads its 4th row (event d) it should say "No" as there is no task with an event ID of 'd'