topic Re: I need to create aggr with FirstSortedValue I can't in App Development https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1897693#M74099 <P>Não entendi direito qual a sua lógica.&nbsp;<BR />Qual a regra de negocio que você precisa?</P><P>Olhando aqui, esse flagx, o que seria?&nbsp;</P><P>O mes de dez 2021, é sempre fixo?</P> Fri, 25 Feb 2022 14:54:23 GMT Clever_Anjos 2022-02-25T14:54:23Z I need to create aggr with FirstSortedValue I can't https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894813#M73814 <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução"><SPAN class="Y2IQFc">wrong set analysis</SPAN></PRE> <P>FirstSortedValue({1&lt; [MesAno] = {'dez 2021'},[Flagx] = {'1'}&gt;} PRECOUNITARIO,-horab)</P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução"><SPAN class="Y2IQFc">how is it going</SPAN></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-02-18_09-22-03.jpg" style="width: 587px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72626i94E27F6E289E0347/image-size/large?v=v2&amp;px=999" role="button" title="2022-02-18_09-22-03.jpg" alt="2022-02-18_09-22-03.jpg" /></span></P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução"><SPAN class="Y2IQFc">as you need it to stay</SPAN></PRE> <TABLE width="571"> <TBODY> <TR> <TD width="98">Produto</TD> <TD width="119">CODIGOGRUPO</TD> <TD width="158">CODIGOMATERIAPRIMA</TD> <TD width="98">Quantidade</TD> <TD width="98">Result</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>3</TD> <TD>10,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>18</TD> <TD>0,006</TD> <TD>18,8491</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>78</TD> <TD>0,002</TD> <TD>8,103</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>114</TD> <TD>0,013</TD> <TD>18,636</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>151</TD> <TD>1,000</TD> <TD>4,60547</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>162</TD> <TD>15,000</TD> <TD>0,0063</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>202</TD> <TD>0,027</TD> <TD>5,034219</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>643</TD> <TD>1,000</TD> <TD>0,0065</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>705</TD> <TD>15,000</TD> <TD>0,0238</TD> </TR> <TR> <TD>212</TD> <TD>12</TD> <TD>1164</TD> <TD>0,816</TD> <TD>0,245714</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Fri, 18 Feb 2022 12:26:43 GMT https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894813#M73814 Paula1 2022-02-18T12:26:43Z Re: I need to create aggr with FirstSortedValue I can't https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894967#M73831 <P>Help</P> Fri, 18 Feb 2022 18:42:56 GMT https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894967#M73831 Paula1 2022-02-18T18:42:56Z Re: I need to create aggr with FirstSortedValue I can't https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894981#M73833 <P>aggr(FirstSortedValue([PRECOUNITARIO],-Aggr(Min({&lt;[MesAno]={'dez 2021'} &gt;}horab),Produto,CODIGOGRUPO,CODIGOMATERIAPRIMA)),Produto,CODIGOGRUPO,CODIGOMATERIAPRIMA)</P> <P>No<span class="lia-unicode-emoji" title=":thinking_face:">🤔</span></P> <P>&nbsp;</P> Fri, 18 Feb 2022 20:02:31 GMT https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894981#M73833 Paula1 2022-02-18T20:02:31Z Re: I need to create aggr with FirstSortedValue I can't https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894982#M73834 <P>Help</P> Fri, 18 Feb 2022 20:02:46 GMT https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1894982#M73834 Paula1 2022-02-18T20:02:46Z Re: I need to create aggr with FirstSortedValue I can't https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1897693#M74099 <P>Não entendi direito qual a sua lógica.&nbsp;<BR />Qual a regra de negocio que você precisa?</P><P>Olhando aqui, esse flagx, o que seria?&nbsp;</P><P>O mes de dez 2021, é sempre fixo?</P> Fri, 25 Feb 2022 14:54:23 GMT https://community.qlik.com/t5/App-Development/I-need-to-create-aggr-with-FirstSortedValue-I-can-t/m-p/1897693#M74099 Clever_Anjos 2022-02-25T14:54:23Z