topic Re: How can I do to find the quartiles, by one variable and weighted by another. in App Development https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232660#M24124 <HTML><HEAD></HEAD><BODY><P>What is the expected output from this data?</P></BODY></HTML> Wed, 08 Feb 2017 12:07:18 GMT sunny_talwar 2017-02-08T12:07:18Z How can I do to find the quartiles, by one variable and weighted by another. https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232659#M24123 <HTML><HEAD></HEAD><BODY><P> Hi, </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 802px;"><TBODY><TR><TD class="xl63" height="18" width="802">How can I do to find the quartiles, by one variable and weighted by another.</TD></TR><TR><TD class="xl63" height="18">For example, in the following data, I wanted the quartiles of the amount variable, by code and weighted by the quantity variable.</TD></TR><TR><TD class="xl63" height="18">Input frame date</TD></TR><TR><TD class="xl63" height="18">&nbsp;&nbsp;&nbsp; code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; quantity</TD></TR><TR><TD class="xl63" height="18">&nbsp;&nbsp;&nbsp; 1.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35867.14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125</TD></TR><TR><TD class="xl63" height="18">&nbsp;&nbsp;&nbsp; 1.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5867.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1045</TD></TR><TR><TD class="xl63" height="18">&nbsp;&nbsp;&nbsp; 1.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 62100.14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91</TD></TR><TR><TD class="xl63" height="18">&nbsp;&nbsp;&nbsp; 1.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35,000.99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21</TD></TR><TR><TD class="xl63" height="18">&nbsp;&nbsp;&nbsp; 1.02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 401.87&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2650</TD></TR><TR><TD class="xl64" height="18">&nbsp;&nbsp;&nbsp; 1.02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 815.7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10345</TD></TR><TR><TD class="xl64" height="18"></TD></TR></TBODY></TABLE><P>Thanks</P></BODY></HTML> Tue, 07 Feb 2017 23:48:00 GMT https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232659#M24123 agenorcanal 2017-02-07T23:48:00Z Re: How can I do to find the quartiles, by one variable and weighted by another. https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232660#M24124 <HTML><HEAD></HEAD><BODY><P>What is the expected output from this data?</P></BODY></HTML> Wed, 08 Feb 2017 12:07:18 GMT https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232660#M24124 sunny_talwar 2017-02-08T12:07:18Z Re: How can I do to find the quartiles, by one variable and weighted by another. https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232661#M24125 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P>To code 1.01: Quartile 0,25 and&nbsp; Quartile 0,5 and Quartile 0,75 = 5867.05.</P></BODY></HTML> Wed, 08 Feb 2017 19:45:37 GMT https://community.qlik.com/t5/App-Development/How-can-I-do-to-find-the-quartiles-by-one-variable-and-weighted/m-p/1232661#M24125 agenorcanal 2017-02-08T19:45:37Z