topic Problem with Renewal Rate Calculation in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810735#M286228 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Please see data example below (left) and Straight table needed below (right). I need to show Renewals by Effective_Date in 2015 (I can get this), and show the respective renewal rate.&nbsp; Renewal Rate = Renewals / Renewal Base, where Renewal Base is the number of contracts that expired (Expiration_Date) on the respective Effective Date.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Thanks for any assistance you can provide.<BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"><BR /></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 668px;"><TBODY><TR><TD colspan="3" nowrap="nowrap" style="background: #0070C0; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="284"><P align="center" style="text-align: center;"><STRONG style="color: white;">Data</STRONG></P></TD><TD colspan="4" nowrap="nowrap" style="background: #0070C0; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="363"><P align="center" style="text-align: center;"><SPAN style="color: white;">Straight Table Needed</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P><SPAN style="color: black;">Contract_ID</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P><SPAN style="color: black;">Effective_Date</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">Expiration_Date</SPAN></P></TD><TD style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="center" style="text-align: center;"><STRONG style="color: black;">Period </STRONG><SPAN style="color: black;">(Renewal Effective Mo.)</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><STRONG style="color: black;">Renewals</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="center" style="text-align: center;"><STRONG style="color: black;">Renewal Base</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="center" style="text-align: center;"><STRONG style="color: black;">Renewal Rate</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">50%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">50%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P><SPAN style="color: black;">Total</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">83%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">14</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">16</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">18</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">19</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">21</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2016</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 01 Mar 2015 22:25:50 GMT 2015-03-01T22:25:50Z Problem with Renewal Rate Calculation https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810735#M286228 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Please see data example below (left) and Straight table needed below (right). I need to show Renewals by Effective_Date in 2015 (I can get this), and show the respective renewal rate.&nbsp; Renewal Rate = Renewals / Renewal Base, where Renewal Base is the number of contracts that expired (Expiration_Date) on the respective Effective Date.</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;">Thanks for any assistance you can provide.<BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"><BR /></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 668px;"><TBODY><TR><TD colspan="3" nowrap="nowrap" style="background: #0070C0; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="284"><P align="center" style="text-align: center;"><STRONG style="color: white;">Data</STRONG></P></TD><TD colspan="4" nowrap="nowrap" style="background: #0070C0; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="363"><P align="center" style="text-align: center;"><SPAN style="color: white;">Straight Table Needed</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P><SPAN style="color: black;">Contract_ID</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P><SPAN style="color: black;">Effective_Date</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P><SPAN style="color: black;">Expiration_Date</SPAN></P></TD><TD style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="center" style="text-align: center;"><STRONG style="color: black;">Period </STRONG><SPAN style="color: black;">(Renewal Effective Mo.)</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><STRONG style="color: black;">Renewals</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="center" style="text-align: center;"><STRONG style="color: black;">Renewal Base</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="center" style="text-align: center;"><STRONG style="color: black;">Renewal Rate</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">50%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">100%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">50%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="91"><P><SPAN style="color: black;">Total</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="101"><P align="right" style="text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="100"><P align="right" style="text-align: right;"><SPAN style="color: black;">83%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2014</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">14</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/2/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">16</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">1/3/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">18</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">19</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/1/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">21</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/2/2016</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P align="right" style="text-align: right;"><SPAN style="color: black;">22</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="97"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2015</SPAN></P></TD><TD nowrap="nowrap" style="background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="right" style="text-align: right;"><SPAN style="color: black;">2/3/2016</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Sun, 01 Mar 2015 22:25:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810735#M286228 2015-03-01T22:25:50Z Re: Problem with Renewal Rate Calculation https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810736#M286229 <HTML><HEAD></HEAD><BODY><P>Check enclosed file... I have considered that your date format is D/M/YYYY.</P></BODY></HTML> Sun, 01 Mar 2015 22:30:05 GMT https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810736#M286229 MK_QSL 2015-03-01T22:30:05Z Re: Problem with Renewal Rate Calculation https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810737#M286230 <HTML><HEAD></HEAD><BODY><P>Thank you Manish.&nbsp; I was thinking that another date needed to be introduced, but was not sure how to do that.&nbsp; I think I can make this approach work.</P></BODY></HTML> Mon, 02 Mar 2015 15:57:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-Renewal-Rate-Calculation/m-p/810737#M286230 2015-03-02T15:57:50Z