topic Descending Calculation in QlikView https://community.qlik.com/t5/QlikView/Descending-Calculation/m-p/172894#M42284 <HTML><HEAD></HEAD><BODY><P>I may be getting closer, but still can't find a way to have the calculated range accumulate internally. I can use concat to get the range of values returned in descending order, but when I use <I>above</I> to get the accumulating values, they aren't coming in descending order. Any suggestions?</P></BODY></HTML> Tue, 08 Dec 2009 05:10:10 GMT 2009-12-08T05:10:10Z Descending Calculation https://community.qlik.com/t5/QlikView/Descending-Calculation/m-p/172893#M42283 <HTML><HEAD></HEAD><BODY><P>I am trying to build an expression that will take a series of expression results and give me the sum of the top X results. X will be based on number Y.</P><P>For example, take this set of results:</P><P></P><TABLE border="1"><TBODY><TR><TD>Occurrence</TD><TD>Value</TD></TR><TR><TD>39537</TD><TD>118556.10</TD></TR><TR><TD>24570</TD><TD>115666.24</TD></TR><TR><TD>38604</TD><TD>48317.64</TD></TR><TR><TD>40729</TD><TD>31146.74</TD></TR><TR><TD>28534</TD><TD>5408.67</TD></TR><TR><TD>32292</TD><TD>2608.14</TD></TR><TR><TD>36582</TD><TD>1959.76</TD></TR><TR><TD>50463</TD><TD>1900.01</TD></TR><TR><TD>32461</TD><TD>1716.10</TD></TR><TR><TD>28001</TD><TD>1627.92</TD></TR><TR><TD>28777</TD><TD>1316.53</TD></TR><TR><TD>36647</TD><TD>1211.20</TD></TR></TBODY></TABLE><BR /><BR /> <P>If number Y was 100,000, I need the expression to return 118,556.10 for X. If number Y was 200,000, I need the expression to return 234,222.34 for X.</P><P>I am trying to return the point at which the sum of values (X) fully exhausts a fund (Y). The variance of these numbers (18,556.10 and 34,222.34 respectively in the examples above) is the figure I need. If the calculation does not sort descending as it is processed, the variance will not be correct.</P><P>The place I'm getting stuck is in identifying the limit in the sort order as a returned value. If I can find the break point, I can then use that figure to cap the sum or apply some kind of ranking.</P><P>Hopefully that made some sense. Any suggestions would be greatly appreciated!!</P></BODY></HTML> Wed, 02 Dec 2009 23:27:46 GMT https://community.qlik.com/t5/QlikView/Descending-Calculation/m-p/172893#M42283 2009-12-02T23:27:46Z Descending Calculation https://community.qlik.com/t5/QlikView/Descending-Calculation/m-p/172894#M42284 <HTML><HEAD></HEAD><BODY><P>I may be getting closer, but still can't find a way to have the calculated range accumulate internally. I can use concat to get the range of values returned in descending order, but when I use <I>above</I> to get the accumulating values, they aren't coming in descending order. Any suggestions?</P></BODY></HTML> Tue, 08 Dec 2009 05:10:10 GMT https://community.qlik.com/t5/QlikView/Descending-Calculation/m-p/172894#M42284 2009-12-08T05:10:10Z