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