topic Re: BASE YEAR FORMULA in QlikView https://community.qlik.com/t5/QlikView/BASE-YEAR-FORMULA/m-p/495978#M185460 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Sum({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">período </SPAN>={'2013-02'}&gt;}Sales)/ Sum(Sales)</P></BODY></HTML> Thu, 07 Nov 2013 20:54:26 GMT MayilVahanan 2013-11-07T20:54:26Z BASE YEAR FORMULA https://community.qlik.com/t5/QlikView/BASE-YEAR-FORMULA/m-p/495977#M185459 <HTML><HEAD></HEAD><BODY><P>Hello everybody:</P><P>I'm trying to compare everi month sale with a single month (2013-02) to get de % of variation.</P><P>Can anybody recomend a formula to do this?</P><P>Thanks!</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;" width="473"><TBODY style="font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="98">SUC_Descripcion</TD><TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="75">FormaPago</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="36">PeriodoFactura</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="66">2013-02</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="66">2013-03</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="66">2013-04</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="66">2013-05</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Credito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.098</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">10.308</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">5.825</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">5.862</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Debito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.180</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">5.680</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">4.363</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">4.534</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Efectivo</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">12.628</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">19.059</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">8.664</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">15.739</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">24.905</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">35.047</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">18.851</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">26.135</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Credito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">8.265</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">17.474</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">14.331</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">13.034</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Debito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">7.182</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">10.094</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">9.369</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">10.845</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Efectivo</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">17.223</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">48.588</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">36.368</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">40.749</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">32.670</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">76.155</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">60.068</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">64.628</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD class="xl72" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">57.575</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">111.202</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">78.919</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">90.762</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD class="xl63" height="18" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SUC_Descripcion</TD><TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">FormaPago</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">PeriodoFactura</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-02</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-03</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-04</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-05</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Credito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.098</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.098</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.098</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.098</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Debito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.180</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.180</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.180</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">6.180</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Efectivo</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">12.628</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">12.628</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">12.628</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">12.628</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">24.905</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">24.905</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">24.905</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">24.905</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Credito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">8.265</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">8.265</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">8.265</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">8.265</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Debito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">7.182</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">7.182</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">7.182</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">7.182</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Efectivo</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">17.223</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">17.223</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">17.223</TD><TD align="right" class="xl68" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">17.223</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">32.670</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">32.670</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">32.670</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">32.670</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD class="xl72" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">57.575</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">57.575</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">57.575</TD><TD align="right" class="xl69" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">57.575</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD class="xl63" height="18" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SUC_Descripcion</TD><TD class="xl63" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">FormaPago</TD><TD class="xl64" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">PeriodoFactura</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-02</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-03</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-04</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">2013-05</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Credito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">59%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">105%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">104%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Debito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">109%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">142%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">136%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Efectivo</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">66%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">146%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">80%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">1</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">71%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">132%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">95%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Credito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">47%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">58%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">63%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Debito</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">71%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">77%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">66%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">Efectivo</TD><TD class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">35%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">47%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">42%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD align="right" class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">43%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">54%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">51%</TD></TR><TR style="border: 0px; font-style: inherit; font-family: inherit;"><TD class="xl72" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">Total</TD><TD class="xl70" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;"></TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">100%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">52%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">73%</TD><TD align="right" class="xl73" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">63%</TD></TR></TBODY></TABLE><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hola:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Necesito ayuda para generar una tabla pivotante que calcule la variación mensual respecto a un período (2013-02)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Alguna recomendación?<BR />Gracias!</P></BODY></HTML> Thu, 07 Nov 2013 20:20:50 GMT https://community.qlik.com/t5/QlikView/BASE-YEAR-FORMULA/m-p/495977#M185459 2013-11-07T20:20:50Z Re: BASE YEAR FORMULA https://community.qlik.com/t5/QlikView/BASE-YEAR-FORMULA/m-p/495978#M185460 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Sum({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">período </SPAN>={'2013-02'}&gt;}Sales)/ Sum(Sales)</P></BODY></HTML> Thu, 07 Nov 2013 20:54:26 GMT https://community.qlik.com/t5/QlikView/BASE-YEAR-FORMULA/m-p/495978#M185460 MayilVahanan 2013-11-07T20:54:26Z