topic table calculations in App Development https://community.qlik.com/t5/App-Development/table-calculations/m-p/1427950#M34158 <HTML><HEAD></HEAD><BODY><P>Does Qlik Sense (2017 06) have embedded functions that would allow table calculations (average, max, min) based on different levels of aggregation inside a pivot table.</P><P></P><P>I'm trying to show periodic (YTD, current quarter, current month) averages at individual company, individual division and individual department where departments belong to divisions and divisions belong to companies.&nbsp;&nbsp; I'd also like to see those averages at total enterprise (sum of all companies).</P><P></P><P>Right now in the pivot table I'm able to create an average at one level, but when I change levels then the averages are not calculating correctly.&nbsp; I think we can come up with formulae that might get us there but notices Tableau appears to have embedded 'table functions' that allow calculations based on table summarizations.&nbsp;&nbsp; I can't seem to find similar functionality in Sense.</P><P></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Having to create unique formulae in each app seems counterproductive </SPAN></P><P>Is this there and I just haven't found it or recognized it?</P><P>If not - when is this coming?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 18 Aug 2017 15:11:28 GMT Jon_M 2017-08-18T15:11:28Z table calculations https://community.qlik.com/t5/App-Development/table-calculations/m-p/1427950#M34158 <HTML><HEAD></HEAD><BODY><P>Does Qlik Sense (2017 06) have embedded functions that would allow table calculations (average, max, min) based on different levels of aggregation inside a pivot table.</P><P></P><P>I'm trying to show periodic (YTD, current quarter, current month) averages at individual company, individual division and individual department where departments belong to divisions and divisions belong to companies.&nbsp;&nbsp; I'd also like to see those averages at total enterprise (sum of all companies).</P><P></P><P>Right now in the pivot table I'm able to create an average at one level, but when I change levels then the averages are not calculating correctly.&nbsp; I think we can come up with formulae that might get us there but notices Tableau appears to have embedded 'table functions' that allow calculations based on table summarizations.&nbsp;&nbsp; I can't seem to find similar functionality in Sense.</P><P></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Having to create unique formulae in each app seems counterproductive </SPAN></P><P>Is this there and I just haven't found it or recognized it?</P><P>If not - when is this coming?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 18 Aug 2017 15:11:28 GMT https://community.qlik.com/t5/App-Development/table-calculations/m-p/1427950#M34158 Jon_M 2017-08-18T15:11:28Z