topic Hierarchy(chain) in selection in App Development https://community.qlik.com/t5/App-Development/Hierarchy-chain-in-selection/m-p/87918#M5862 <HTML><HEAD></HEAD><BODY><P>There are 3 tables.</P><P>1) Actions</P><P>2) Deals</P><P>3) Marketing campaigns</P><P></P><P>I have 1 action which has marketing campaign filled in, this action can have 1 or many deals connected to it.</P><P>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.</P><P></P><P>Chain looks something like this - marketing campaign - action - (1..n) child actions - deal</P><P></P><P>What can I use to select all deals no matter how many actions connect it to the marketing campaign?</P><P>I need to build table in QlikSense with results of campaign</P></BODY></HTML> Wed, 15 Aug 2018 12:53:15 GMT Anonymous 2018-08-15T12:53:15Z Hierarchy(chain) in selection https://community.qlik.com/t5/App-Development/Hierarchy-chain-in-selection/m-p/87918#M5862 <HTML><HEAD></HEAD><BODY><P>There are 3 tables.</P><P>1) Actions</P><P>2) Deals</P><P>3) Marketing campaigns</P><P></P><P>I have 1 action which has marketing campaign filled in, this action can have 1 or many deals connected to it.</P><P>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.</P><P></P><P>Chain looks something like this - marketing campaign - action - (1..n) child actions - deal</P><P></P><P>What can I use to select all deals no matter how many actions connect it to the marketing campaign?</P><P>I need to build table in QlikSense with results of campaign</P></BODY></HTML> Wed, 15 Aug 2018 12:53:15 GMT https://community.qlik.com/t5/App-Development/Hierarchy-chain-in-selection/m-p/87918#M5862 Anonymous 2018-08-15T12:53:15Z