topic How to find growth % ? in QlikView https://community.qlik.com/t5/QlikView/How-to-find-growth/m-p/301810#M498000 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to code some thing like this for Growth% </P><P>If(Year(<STRONG style="font-size: 12px;">Duration</STRONG>)= Yearstart(Today()) , Growth%) </P><P></P><P>For Growth% calculation it should work better </P><P>Hope this helps you.</P><P></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 26 Aug 2011 06:43:01 GMT its_anandrjs 2011-08-26T06:43:01Z How to find growth % ? https://community.qlik.com/t5/QlikView/How-to-find-growth/m-p/301809#M497999 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have a pivot table with month-year as Row and the retention % as data. I need to find out the growth between the current yr's month against last years.</P><P></P><P>This is how the table looks. </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Duration</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG style="color: #ffffff;"><STRONG>Retention %</STRONG></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Growth%</STRONG></SPAN></TH></TR><TR><TD><P>APR 2009 </P></TD><TD>20%</TD><TD></TD></TR><TR><TD>MAY 2009</TD><TD>40%</TD><TD></TD></TR><TR><TD>APR 2010</TD><TD>40%</TD><TD>100%</TD></TR><TR><TD>MAY 2010</TD><TD>50%</TD><TD>25%</TD></TR><TR><TD>JUN 2010</TD><TD>60%</TD><TD>100%</TD></TR><TR><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 26 Aug 2011 04:51:43 GMT https://community.qlik.com/t5/QlikView/How-to-find-growth/m-p/301809#M497999 2011-08-26T04:51:43Z How to find growth % ? https://community.qlik.com/t5/QlikView/How-to-find-growth/m-p/301810#M498000 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to code some thing like this for Growth% </P><P>If(Year(<STRONG style="font-size: 12px;">Duration</STRONG>)= Yearstart(Today()) , Growth%) </P><P></P><P>For Growth% calculation it should work better </P><P>Hope this helps you.</P><P></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 26 Aug 2011 06:43:01 GMT https://community.qlik.com/t5/QlikView/How-to-find-growth/m-p/301810#M498000 its_anandrjs 2011-08-26T06:43:01Z