topic How Do I recreate this Aging Pivot Done In Excel in QlikView

topic How Do I recreate this Aging Pivot Done In Excel in QlikView https://community.qlik.com/t5/QlikView/How-Do-I-recreate-this-Aging-Pivot-Done-In-Excel/m-p/563300#M210203 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="448"><TBODY><TR><TD height="20" width="64"><BR /></TD><TD class="xl63" width="64">Period</TD><TD class="xl63" width="64">Period+1</TD><TD class="xl63" width="64">Period+2</TD><TD class="xl63" width="64">Period+3</TD><TD class="xl63" width="64">Period+4</TD><TD class="xl63" width="64">Period+5</TD></TR><TR><TD class="xl64" height="33" width="64">Dec12 sales</TD><TD class="xl65" style="border-left: none;" width="64">49%</TD><TD class="xl65" style="border-left: none;" width="64">59%</TD><TD class="xl65" style="border-left: none;" width="64">67%</TD><TD class="xl65" style="border-left: none;" width="64">70%</TD><TD class="xl65" style="border-left: none;" width="64">72%</TD><TD class="xl65" style="border-left: none;" width="64">74%</TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">Jan13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">51%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">56%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">59%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">66%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">69%</TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">Feb13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">47%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">52%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">56%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">63%</TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">Mar13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">49%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">48%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">50%</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">April13, sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">41%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">45%</TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">May13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">39%</TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P>The above pivot created in excel expresses the aging vintages to which Period refers to the min activity period.  </P></BODY></HTML> Thu, 11 Jul 2013 14:36:02 GMT 2013-07-11T14:36:02Z How Do I recreate this Aging Pivot Done In Excel https://community.qlik.com/t5/QlikView/How-Do-I-recreate-this-Aging-Pivot-Done-In-Excel/m-p/563300#M210203 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="448"><TBODY><TR><TD height="20" width="64"><BR /></TD><TD class="xl63" width="64">Period</TD><TD class="xl63" width="64">Period+1</TD><TD class="xl63" width="64">Period+2</TD><TD class="xl63" width="64">Period+3</TD><TD class="xl63" width="64">Period+4</TD><TD class="xl63" width="64">Period+5</TD></TR><TR><TD class="xl64" height="33" width="64">Dec12 sales</TD><TD class="xl65" style="border-left: none;" width="64">49%</TD><TD class="xl65" style="border-left: none;" width="64">59%</TD><TD class="xl65" style="border-left: none;" width="64">67%</TD><TD class="xl65" style="border-left: none;" width="64">70%</TD><TD class="xl65" style="border-left: none;" width="64">72%</TD><TD class="xl65" style="border-left: none;" width="64">74%</TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">Jan13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">51%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">56%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">59%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">66%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">69%</TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">Feb13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">47%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">52%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">56%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">63%</TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">Mar13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">49%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">48%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">50%</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">April13, sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">41%</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">45%</TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="33" style="border-top: none;" width="64">May13 sales</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">39%</TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P>The above pivot created in excel expresses the aging vintages to which Period refers to the min activity period.  </P></BODY></HTML> Thu, 11 Jul 2013 14:36:02 GMT https://community.qlik.com/t5/QlikView/How-Do-I-recreate-this-Aging-Pivot-Done-In-Excel/m-p/563300#M210203 2013-07-11T14:36:02Z