Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simontouyet
Contributor
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'

0 Replies