topic Question regarding the usage of aggr in App Development https://community.qlik.com/t5/App-Development/Question-regarding-the-usage-of-aggr/m-p/1403018#M32682 <HTML><HEAD></HEAD><BODY><P>I want to calculate standard deviation divided by the avg value . I know the basic function but there is a problem.</P><P>I want to calculate the <SPAN style="font-size: 13.3333px;">standard </SPAN>deviation at product level considering the other filters ( Like Date,Customer , Supplier) .</P><P>In table my dimension is Week that is fine and working fine but It is summing the quantity across the products while calculating the <SPAN style="font-size: 13.3333px;">standard </SPAN><SPAN style="font-size: 13.3333px;">deviation. I want it to do the aggregation at product level while calculating the <SPAN style="font-size: 13.3333px;">stdev/avg and the show the average. </SPAN></SPAN></P><P>Not sure how exactly we neef to write it&nbsp; hence showing two different approaches in below expression</P><P></P><P>/stdev(&nbsp; if((LeadTimeInWeeks &gt;=AbsDeltaWeek), aggr(sum(DemandQty),<SPAN style="text-decoration: underline;"><STRONG>DeltaWeek</STRONG></SPAN>),Null()))</P><P>/avg(if((LeadTimeInWeeks &gt;=AbsDeltaWeek), <SPAN style="font-size: 13.3333px;">aggr(sum(DemandQty),<STRONG style="text-decoration: underline;">ProductName</STRONG>)</SPAN>,Null()))</P><P></P><P>Qlik documentation can add more example for <SPAN style="font-size: 13.3333px;">aggr , I feel.</SPAN></P></BODY></HTML> Thu, 30 Nov 2017 08:49:50 GMT Anonymous 2017-11-30T08:49:50Z Question regarding the usage of aggr https://community.qlik.com/t5/App-Development/Question-regarding-the-usage-of-aggr/m-p/1403018#M32682 <HTML><HEAD></HEAD><BODY><P>I want to calculate standard deviation divided by the avg value . I know the basic function but there is a problem.</P><P>I want to calculate the <SPAN style="font-size: 13.3333px;">standard </SPAN>deviation at product level considering the other filters ( Like Date,Customer , Supplier) .</P><P>In table my dimension is Week that is fine and working fine but It is summing the quantity across the products while calculating the <SPAN style="font-size: 13.3333px;">standard </SPAN><SPAN style="font-size: 13.3333px;">deviation. I want it to do the aggregation at product level while calculating the <SPAN style="font-size: 13.3333px;">stdev/avg and the show the average. </SPAN></SPAN></P><P>Not sure how exactly we neef to write it&nbsp; hence showing two different approaches in below expression</P><P></P><P>/stdev(&nbsp; if((LeadTimeInWeeks &gt;=AbsDeltaWeek), aggr(sum(DemandQty),<SPAN style="text-decoration: underline;"><STRONG>DeltaWeek</STRONG></SPAN>),Null()))</P><P>/avg(if((LeadTimeInWeeks &gt;=AbsDeltaWeek), <SPAN style="font-size: 13.3333px;">aggr(sum(DemandQty),<STRONG style="text-decoration: underline;">ProductName</STRONG>)</SPAN>,Null()))</P><P></P><P>Qlik documentation can add more example for <SPAN style="font-size: 13.3333px;">aggr , I feel.</SPAN></P></BODY></HTML> Thu, 30 Nov 2017 08:49:50 GMT https://community.qlik.com/t5/App-Development/Question-regarding-the-usage-of-aggr/m-p/1403018#M32682 Anonymous 2017-11-30T08:49:50Z Re: Question regarding the usage of aggr https://community.qlik.com/t5/App-Development/Question-regarding-the-usage-of-aggr/m-p/1403019#M32683 <HTML><HEAD></HEAD><BODY><P>I resolved with the help of video found on youtbute. </P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Segoe UI',sans-serif;"><A class="jive-link-external-small" href="https://www.youtube.com/watch?v=-YsJmdzMHbs" rel="nofollow" target="_blank">https://www.youtube.com/watch?v=-YsJmdzMHbs</A></SPAN>&nbsp; </P></BODY></HTML> Fri, 01 Dec 2017 08:04:59 GMT https://community.qlik.com/t5/App-Development/Question-regarding-the-usage-of-aggr/m-p/1403019#M32683 Anonymous 2017-12-01T08:04:59Z