topic Average income with filters in App Development https://community.qlik.com/t5/App-Development/Average-income-with-filters/m-p/112584#M7744 <HTML><HEAD></HEAD><BODY><P>Dear community,</P><P></P><P>I have the following two custom variables:</P><UL><LI>idvisit</LI><LI>income</LI></UL><P></P><P>and the following field:</P><UL><LI>idaction_name</LI></UL><P></P><P>I would now like to calculate the average <STRONG>income</STRONG>, but only for those <STRONG>idvisit</STRONG> that fullfill a certain <STRONG>idaction_name</STRONG> (e.g. idaction_name = 12345).</P><P>I assume that I have to use a nested aggregation here, but dont know how to proceed.</P><P><BR />Can anyone help?</P><P><BR />Thanks so much in advance!!</P><P></P><P>Best</P><P></P><P>Philipp</P></BODY></HTML> Mon, 10 Sep 2018 14:53:17 GMT Anonymous 2018-09-10T14:53:17Z Average income with filters https://community.qlik.com/t5/App-Development/Average-income-with-filters/m-p/112584#M7744 <HTML><HEAD></HEAD><BODY><P>Dear community,</P><P></P><P>I have the following two custom variables:</P><UL><LI>idvisit</LI><LI>income</LI></UL><P></P><P>and the following field:</P><UL><LI>idaction_name</LI></UL><P></P><P>I would now like to calculate the average <STRONG>income</STRONG>, but only for those <STRONG>idvisit</STRONG> that fullfill a certain <STRONG>idaction_name</STRONG> (e.g. idaction_name = 12345).</P><P>I assume that I have to use a nested aggregation here, but dont know how to proceed.</P><P><BR />Can anyone help?</P><P><BR />Thanks so much in advance!!</P><P></P><P>Best</P><P></P><P>Philipp</P></BODY></HTML> Mon, 10 Sep 2018 14:53:17 GMT https://community.qlik.com/t5/App-Development/Average-income-with-filters/m-p/112584#M7744 Anonymous 2018-09-10T14:53:17Z