topic Re: calculation issue in App Development https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257347#M25504 <HTML><HEAD></HEAD><BODY><P>What do you want to do? Sum the averages or average the averages or something else? </P><P></P><P>If you want the sum of averages try something like this: Sum(aggr(avg(DurationDays),<EM>CompanyNameDimensionHere</EM>,StateDescription))</P></BODY></HTML> Wed, 16 Nov 2016 09:47:19 GMT Gysbert_Wassenaar 2016-11-16T09:47:19Z calculation issue https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257346#M25503 <HTML><HEAD></HEAD><BODY><P>I have the following results&nbsp; (pivot table)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State B<BR />Company A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; avg(DurationDays)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>--<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; State B<BR />Company A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4<BR />Compnay B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P></P><P><BR />Now they want to get&nbsp; a horizontal summary may be in seperate table</P><P></P><P></P><P></P><P>They Want Company A 9 days<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Company B 15 days</P><P></P><P></P><P>tried things like aggr(avg(DurationDays),StateDescription) with the dimension company, but then i get null values</P><P></P><P>how to fix this ?</P></BODY></HTML> Wed, 16 Nov 2016 09:42:49 GMT https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257346#M25503 jsnova 2016-11-16T09:42:49Z Re: calculation issue https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257347#M25504 <HTML><HEAD></HEAD><BODY><P>What do you want to do? Sum the averages or average the averages or something else? </P><P></P><P>If you want the sum of averages try something like this: Sum(aggr(avg(DurationDays),<EM>CompanyNameDimensionHere</EM>,StateDescription))</P></BODY></HTML> Wed, 16 Nov 2016 09:47:19 GMT https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257347#M25504 Gysbert_Wassenaar 2016-11-16T09:47:19Z Re: calculation issue https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257348#M25505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you are using a straight table then try :</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(aggr(avg(DurationDays),Company))</SPAN></P></BODY></HTML> Wed, 16 Nov 2016 09:47:21 GMT https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257348#M25505 sushil353 2016-11-16T09:47:21Z Re: calculation issue https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257349#M25506 <HTML><HEAD></HEAD><BODY><P>Can you plz elaborate little more</P></BODY></HTML> Wed, 16 Nov 2016 09:47:36 GMT https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257349#M25506 2016-11-16T09:47:36Z Re: calculation issue https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257350#M25507 <HTML><HEAD></HEAD><BODY><P>Use <STRONG>Company</STRONG> as dimension</P><P></P><P>Expression</P><P><STRONG>Sum(Aggr(Avg(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>DurationDays), Company, State))</STRONG></SPAN></P></BODY></HTML> Wed, 16 Nov 2016 09:49:53 GMT https://community.qlik.com/t5/App-Development/calculation-issue/m-p/1257350#M25507 sunny_talwar 2016-11-16T09:49:53Z