Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor

Hierarchy(chain) in selection

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

Tags (4)