topic Re: Mismo mes año anterior in App Development https://community.qlik.com/t5/App-Development/Mismo-mes-a%C3%B1o-anterior/m-p/2131027#M91949 <P>Pude resolverlo de la siguiente manera:</P> <P>RangeSum(Above(sum ({&lt;%DATE = {'&gt;=$(=AddMonths(MonthStart(max(LYTD)),-11))&lt;=$(=max(LYTD))'}, Fecha= &gt;} neto_real),12,1))</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tincholiver_0-1698064469178.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118721i0CD5108B241A0F4F/image-size/medium?v=v2&amp;px=400" role="button" title="tincholiver_0-1698064469178.png" alt="tincholiver_0-1698064469178.png" /></span></P> <P>&nbsp;</P> Mon, 23 Oct 2023 12:34:39 GMT tincholiver 2023-10-23T12:34:39Z Mismo mes año anterior https://community.qlik.com/t5/App-Development/Mismo-mes-a%C3%B1o-anterior/m-p/2129697#M91858 <P>Hola a todos, no se como resolver este caso:</P> <P>Quiero comparar las ventas de un mes respecto al mismo mes del año anterior teniendo como dimension añomes.</P> <P>El resultado que obtengo es el siguiente:</P> <TABLE width="372"> <TBODY> <TR> <TD width="80">Periodo&nbsp;</TD> <TD width="141">Año_Actual&nbsp;</TD> <TD width="151">Mismo Mes AA&nbsp;</TD> </TR> <TR> <TD width="80">202207</TD> <TD width="141">0</TD> <TD width="151">1.434.466.439</TD> </TR> <TR> <TD width="80">202208</TD> <TD width="141">0</TD> <TD width="151">2.190.627.479</TD> </TR> <TR> <TD width="80">202209</TD> <TD width="141">0</TD> <TD width="151">4.182.858.700</TD> </TR> <TR> <TD width="80">202307</TD> <TD width="141">3.393.930.950</TD> <TD width="151">0</TD> </TR> <TR> <TD width="80">202308</TD> <TD width="141">9.334.550.742</TD> <TD width="151">0</TD> </TR> <TR> <TD width="80">202309</TD> <TD width="141">10.241.121.542</TD> <TD width="151">0</TD> </TR> <TR> <TD width="80">Total&nbsp;</TD> <TD width="141">22.969.603.234</TD> <TD width="151">7.807.952.618</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>el que busco es este:</P> <TABLE width="372"> <TBODY> <TR> <TD width="79.875px" height="24px">Periodo&nbsp;</TD> <TD width="140.725px" height="24px">Año_Actual&nbsp;</TD> <TD width="150.6px" height="24px">Mismo Mes AA&nbsp;</TD> </TR> <TR> <TD width="79.875px" height="24px">202307</TD> <TD width="140.725px" height="24px">3.393.930.950</TD> <TD width="150.6px" height="24px">1.434.466.439</TD> </TR> <TR> <TD width="79.875px" height="24px">202308</TD> <TD width="140.725px" height="24px">9.334.550.742</TD> <TD width="150.6px" height="24px">2.190.627.479</TD> </TR> <TR> <TD width="79.875px" height="24px">202309</TD> <TD width="140.725px" height="24px">10.241.121.542</TD> <TD width="150.6px" height="24px">4.182.858.700</TD> </TR> <TR> <TD width="79.875px" height="24px">Total&nbsp;</TD> <TD width="140.725px" height="24px">22.969.603.234</TD> <TD width="150.6px" height="24px">7.807.952.618</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Alguna idea?&nbsp;</P> <P>Muchas gracias</P> Wed, 18 Oct 2023 18:30:08 GMT https://community.qlik.com/t5/App-Development/Mismo-mes-a%C3%B1o-anterior/m-p/2129697#M91858 tincholiver 2023-10-18T18:30:08Z Re: Mismo mes año anterior https://community.qlik.com/t5/App-Development/Mismo-mes-a%C3%B1o-anterior/m-p/2131027#M91949 <P>Pude resolverlo de la siguiente manera:</P> <P>RangeSum(Above(sum ({&lt;%DATE = {'&gt;=$(=AddMonths(MonthStart(max(LYTD)),-11))&lt;=$(=max(LYTD))'}, Fecha= &gt;} neto_real),12,1))</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tincholiver_0-1698064469178.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118721i0CD5108B241A0F4F/image-size/medium?v=v2&amp;px=400" role="button" title="tincholiver_0-1698064469178.png" alt="tincholiver_0-1698064469178.png" /></span></P> <P>&nbsp;</P> Mon, 23 Oct 2023 12:34:39 GMT https://community.qlik.com/t5/App-Development/Mismo-mes-a%C3%B1o-anterior/m-p/2131027#M91949 tincholiver 2023-10-23T12:34:39Z