topic Re: set analysis help in QlikView https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400982#M149207 <HTML><HEAD></HEAD><BODY><P>Try with the <SPAN class="Bold">nummin</SPAN> function.</P><P></P><P>By Rebeca</P></BODY></HTML> Wed, 27 Mar 2013 17:47:40 GMT 2013-03-27T17:47:40Z set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400981#M149206 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a simple tab:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 760px;"><TBODY><TR><TD class="xl63" height="17" width="98">CT</TD><TD class="xl63" style="border-left: none;" width="98">Concorrente</TD><TD class="xl63" style="border-left: none;" width="98">ListinoR</TD><TD class="xl63" style="border-left: none;" width="98">OE?</TD><TD class="xl63" style="border-left: none;" width="98">PRIOR</TD><TD class="xl63" style="border-left: none;" width="270">ListinoCOM</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">00751</TD><TD class="xl64" style="border-top: none; border-left: none;">M</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">21,01</TD><TD class="xl64" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,43</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">00751</TD><TD class="xl64" style="border-top: none; border-left: none;">N</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">21,01</TD><TD class="xl64" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">21,44</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">00751</TD><TD class="xl64" style="border-top: none; border-left: none;">T</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">21,01</TD><TD class="xl64" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">17,25</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">00751</TD><TD class="xl64" style="border-top: none; border-left: none;">V</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">21,01</TD><TD class="xl64" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">23,16</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">01570</TD><TD class="xl64" style="border-top: none; border-left: none;">M</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">25</TD><TD class="xl64" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">45,00</TD></TR></TBODY></TABLE><P></P><P>I need to identify the lowest "ListinoCOM" with the lower PRIOR value for each CT, and sum them.</P><P></P><P>In this case, i should sum 17,25 and 45</P><P></P><P>Can someone help me please?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 27 Mar 2013 17:40:59 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400981#M149206 2013-03-27T17:40:59Z Re: set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400982#M149207 <HTML><HEAD></HEAD><BODY><P>Try with the <SPAN class="Bold">nummin</SPAN> function.</P><P></P><P>By Rebeca</P></BODY></HTML> Wed, 27 Mar 2013 17:47:40 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400982#M149207 2013-03-27T17:47:40Z Re: set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400983#M149208 <HTML><HEAD></HEAD><BODY><P>Try min({&lt;PRIOR={"=PRIOR=aggr(nodistinct min(PRIOR),CT)"}&gt;}ListinoCOM). See attached example</P></BODY></HTML> Wed, 27 Mar 2013 18:03:39 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400983#M149208 Gysbert_Wassenaar 2013-03-27T18:03:39Z Re: set analysis help https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400984#M149209 <HTML><HEAD></HEAD><BODY><P>Thank you! It works</P></BODY></HTML> Wed, 27 Mar 2013 18:16:04 GMT https://community.qlik.com/t5/QlikView/set-analysis-help/m-p/400984#M149209 2013-03-27T18:16:04Z