Hierarchy(chain) in selection

[Anonymous]

There are 3 tables.

1) Actions

2) Deals

3) Marketing campaigns

I have 1 action which has marketing campaign filled in, this action can have 1 or many deals connected to it.

Also action can be 'Dial later' type and have sub-actions connected to it. This sub-action can be the same structure - deal or dial later.

Chain looks something like this - marketing campaign - action - (1..n) child actions - deal

What can I use to select all deals no matter how many actions connect it to the marketing campaign?

I need to build table in QlikSense with results of campaign