topic total by two dimensions in table in App Development https://community.qlik.com/t5/App-Development/total-by-two-dimensions-in-table/m-p/1445690#M35105 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i have the following standard table in Qlik Sense:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Airport</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Runway</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Flights</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ff0000;">Usage</SPAN></TH></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">24L</TD><TD style="padding: 2px;">160</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">80%</SPAN></TD></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">24R</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">10%</SPAN></TD></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">25R</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">5%</SPAN></TD></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">25L</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">5%</SPAN></TD></TR><TR><TD style="padding: 2px;">MUC</TD><TD style="padding: 2px;">26L</TD><TD style="padding: 2px;">150</TD><TD style="padding: 2px;"><SPAN style="color: #993300;">75%</SPAN></TD></TR><TR><TD style="padding: 2px;">MUC</TD><TD style="padding: 2px;">26R</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;"><SPAN style="color: #993300;">25%</SPAN></TD></TR></TBODY></TABLE><P></P><P>What I need is the <SPAN style="color: #ff0000;">Usage</SPAN> per Runway per Airport. Airport&nbsp; and Runway are dimensions. </P><P>Flights = SUM(LegID). </P><P></P><P>For Usage I tried with: <SPAN style="font-size: 13.3333px;">SUM(<SPAN style="font-size: 13.3333px;">LegID</SPAN>)/</SPAN>AGGR(SUM(Total <SPAN style="font-size: 13.3333px;">LegID</SPAN>),Airport). However didn't get the expected result. </P><P></P><P>Any idea... maybe something with rangesum/above?</P><P></P><P>Brgds Ralf</P></BODY></HTML> Thu, 12 Oct 2017 19:49:47 GMT 2017-10-12T19:49:47Z total by two dimensions in table https://community.qlik.com/t5/App-Development/total-by-two-dimensions-in-table/m-p/1445690#M35105 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i have the following standard table in Qlik Sense:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Airport</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Runway</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Flights</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ff0000;">Usage</SPAN></TH></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">24L</TD><TD style="padding: 2px;">160</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">80%</SPAN></TD></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">24R</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">10%</SPAN></TD></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">25R</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">5%</SPAN></TD></TR><TR><TD style="padding: 2px;">LAX</TD><TD style="padding: 2px;">25L</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">5%</SPAN></TD></TR><TR><TD style="padding: 2px;">MUC</TD><TD style="padding: 2px;">26L</TD><TD style="padding: 2px;">150</TD><TD style="padding: 2px;"><SPAN style="color: #993300;">75%</SPAN></TD></TR><TR><TD style="padding: 2px;">MUC</TD><TD style="padding: 2px;">26R</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;"><SPAN style="color: #993300;">25%</SPAN></TD></TR></TBODY></TABLE><P></P><P>What I need is the <SPAN style="color: #ff0000;">Usage</SPAN> per Runway per Airport. Airport&nbsp; and Runway are dimensions. </P><P>Flights = SUM(LegID). </P><P></P><P>For Usage I tried with: <SPAN style="font-size: 13.3333px;">SUM(<SPAN style="font-size: 13.3333px;">LegID</SPAN>)/</SPAN>AGGR(SUM(Total <SPAN style="font-size: 13.3333px;">LegID</SPAN>),Airport). However didn't get the expected result. </P><P></P><P>Any idea... maybe something with rangesum/above?</P><P></P><P>Brgds Ralf</P></BODY></HTML> Thu, 12 Oct 2017 19:49:47 GMT https://community.qlik.com/t5/App-Development/total-by-two-dimensions-in-table/m-p/1445690#M35105 2017-10-12T19:49:47Z Re: total by two dimensions in table https://community.qlik.com/t5/App-Development/total-by-two-dimensions-in-table/m-p/1445691#M35106 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>SUM(</STRONG></SPAN><STRONG style="color: #3d3d3d; font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">LegID</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>)/<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">SUM(TOTAL &lt;Airport&gt; </SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LegID</SPAN></STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>)</STRONG></SPAN></SPAN></P></BODY></HTML> Thu, 12 Oct 2017 23:47:19 GMT https://community.qlik.com/t5/App-Development/total-by-two-dimensions-in-table/m-p/1445691#M35106 sunny_talwar 2017-10-12T23:47:19Z