topic Growth Calculation in QlikView https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468155#M557611 <HTML><HEAD></HEAD><BODY><P>Hi Qliker Experts!</P><P></P><P>I have this table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 318px;"><TBODY><TR style="background-color: purple; color: white;"><TD height="20" width="98"><STRONG>City</STRONG></TD><TD width="98"><STRONG>Year</STRONG></TD><TD width="122"><STRONG>Population</STRONG></TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2010</TD><TD class="xl63">1,000,000 </TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2010</TD><TD class="xl63">500,000 </TD></TR><TR><TD height="20">Prague</TD><TD align="right">2010</TD><TD class="xl63">150,000 </TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2010</TD><TD class="xl63">700,000 </TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2011</TD><TD class="xl63">1,072,486 </TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2011</TD><TD class="xl63">535,836 </TD></TR><TR><TD height="20">Prague</TD><TD align="right">2011</TD><TD class="xl63">154,237 </TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2011</TD><TD class="xl63">726,029 </TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2012</TD><TD class="xl63">1,107,510 </TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2012</TD><TD class="xl63">544,556 </TD></TR><TR><TD height="20">Prague</TD><TD align="right">2012</TD><TD class="xl63">158,301 </TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2012</TD><TD class="xl63">755,129 </TD></TR></TBODY></TABLE><P></P><P>ready to be loaded into QV, and I kinda wonder how can I calculate while loading so that I will get this table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 350px;"><TBODY><TR style="background-color: purple; color: white;"><TD height="20" width="98">City</TD><TD width="30">Year</TD><TD width="50">Population</TD><TD width="80">Growth</TD><TD width="50">Growth_Percent</TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2010</TD><TD class="xl65">1,000,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2010</TD><TD class="xl65">500,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Prague</TD><TD align="right">2010</TD><TD class="xl65">150,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2010</TD><TD class="xl65">700,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2011</TD><TD class="xl65">1,072,486 </TD><TD class="xl65">72,486 </TD><TD align="right">7.25</TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2011</TD><TD class="xl65">535,836 </TD><TD class="xl65">35,836 </TD><TD align="right">7.17</TD></TR><TR><TD height="20">Prague</TD><TD align="right">2011</TD><TD class="xl65">154,237 </TD><TD class="xl65">4,237 </TD><TD align="right">2.82</TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2011</TD><TD class="xl65">726,029 </TD><TD class="xl65">26,029 </TD><TD align="right">3.72</TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2012</TD><TD class="xl65">1,107,510 </TD><TD class="xl65">35,024 </TD><TD align="right">3.27</TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2012</TD><TD class="xl65">544,556 </TD><TD class="xl65">8,720 </TD><TD align="right">1.63</TD></TR><TR><TD height="20">Prague</TD><TD align="right">2012</TD><TD class="xl65">158,301 </TD><TD class="xl65">4,064 </TD><TD align="right">2.63</TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2012</TD><TD class="xl65">755,129 </TD><TD class="xl65">29,100 </TD><TD align="right">4.01</TD></TR></TBODY></TABLE><P></P><P>That's the FIRST question.</P><P></P><P></P><P></P><P>And the SECOND is:"How can I create this <STRONG>Growth Chart</STRONG> within QV?"</P><P>Is it possible? </P><P></P><P><IMG __jive_id="42583" alt="Growth.PNG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/42583_Growth.PNG" width="450" /></P><P></P><P></P><P>Any help is appreciated.</P><P>Thank you.</P><P></P><P>A</P></BODY></HTML> Thu, 13 Jun 2013 04:01:39 GMT 2013-06-13T04:01:39Z Growth Calculation https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468155#M557611 <HTML><HEAD></HEAD><BODY><P>Hi Qliker Experts!</P><P></P><P>I have this table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 318px;"><TBODY><TR style="background-color: purple; color: white;"><TD height="20" width="98"><STRONG>City</STRONG></TD><TD width="98"><STRONG>Year</STRONG></TD><TD width="122"><STRONG>Population</STRONG></TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2010</TD><TD class="xl63">1,000,000 </TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2010</TD><TD class="xl63">500,000 </TD></TR><TR><TD height="20">Prague</TD><TD align="right">2010</TD><TD class="xl63">150,000 </TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2010</TD><TD class="xl63">700,000 </TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2011</TD><TD class="xl63">1,072,486 </TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2011</TD><TD class="xl63">535,836 </TD></TR><TR><TD height="20">Prague</TD><TD align="right">2011</TD><TD class="xl63">154,237 </TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2011</TD><TD class="xl63">726,029 </TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2012</TD><TD class="xl63">1,107,510 </TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2012</TD><TD class="xl63">544,556 </TD></TR><TR><TD height="20">Prague</TD><TD align="right">2012</TD><TD class="xl63">158,301 </TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2012</TD><TD class="xl63">755,129 </TD></TR></TBODY></TABLE><P></P><P>ready to be loaded into QV, and I kinda wonder how can I calculate while loading so that I will get this table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 350px;"><TBODY><TR style="background-color: purple; color: white;"><TD height="20" width="98">City</TD><TD width="30">Year</TD><TD width="50">Population</TD><TD width="80">Growth</TD><TD width="50">Growth_Percent</TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2010</TD><TD class="xl65">1,000,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2010</TD><TD class="xl65">500,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Prague</TD><TD align="right">2010</TD><TD class="xl65">150,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2010</TD><TD class="xl65">700,000 </TD><TD class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; </TD><TD align="right">0</TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2011</TD><TD class="xl65">1,072,486 </TD><TD class="xl65">72,486 </TD><TD align="right">7.25</TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2011</TD><TD class="xl65">535,836 </TD><TD class="xl65">35,836 </TD><TD align="right">7.17</TD></TR><TR><TD height="20">Prague</TD><TD align="right">2011</TD><TD class="xl65">154,237 </TD><TD class="xl65">4,237 </TD><TD align="right">2.82</TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2011</TD><TD class="xl65">726,029 </TD><TD class="xl65">26,029 </TD><TD align="right">3.72</TD></TR><TR><TD height="20">Jakarta</TD><TD align="right">2012</TD><TD class="xl65">1,107,510 </TD><TD class="xl65">35,024 </TD><TD align="right">3.27</TD></TR><TR><TD height="20">Madrid</TD><TD align="right">2012</TD><TD class="xl65">544,556 </TD><TD class="xl65">8,720 </TD><TD align="right">1.63</TD></TR><TR><TD height="20">Prague</TD><TD align="right">2012</TD><TD class="xl65">158,301 </TD><TD class="xl65">4,064 </TD><TD align="right">2.63</TD></TR><TR><TD height="20">Melbourne</TD><TD align="right">2012</TD><TD class="xl65">755,129 </TD><TD class="xl65">29,100 </TD><TD align="right">4.01</TD></TR></TBODY></TABLE><P></P><P>That's the FIRST question.</P><P></P><P></P><P></P><P>And the SECOND is:"How can I create this <STRONG>Growth Chart</STRONG> within QV?"</P><P>Is it possible? </P><P></P><P><IMG __jive_id="42583" alt="Growth.PNG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/42583_Growth.PNG" width="450" /></P><P></P><P></P><P>Any help is appreciated.</P><P>Thank you.</P><P></P><P>A</P></BODY></HTML> Thu, 13 Jun 2013 04:01:39 GMT https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468155#M557611 2013-06-13T04:01:39Z Re: Growth Calculation https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468156#M557612 <HTML><HEAD></HEAD><BODY><P>may be this is not to the point but yes You can get an idea from this sample</P></BODY></HTML> Thu, 13 Jun 2013 04:33:23 GMT https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468156#M557612 sujeetsingh 2013-06-13T04:33:23Z Re: Growth Calculation https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468157#M557613 <HTML><HEAD></HEAD><BODY><P>Found it!</P><P></P><P>Just use function <STRONG style="font-family: 'courier new', courier;">above()</STRONG></P><P><SPAN style="font-family: 'courier new', courier;"> </SPAN></P><P><STRONG style="font-family: 'courier new', courier;">Growth_Percent = (Growth - above(Growth)) / above(Growth)</STRONG></P><P></P><P>Make sure that all dimensions and expressions you defined sorted in the same order.</P><P>Ciao!</P><P></P><P>A</P></BODY></HTML> Fri, 14 Jun 2013 08:36:03 GMT https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468157#M557613 2013-06-14T08:36:03Z Re: Growth Calculation https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468158#M557614 <HTML><HEAD></HEAD><BODY><P>Can you please attach the sample application which contains this chart?</P></BODY></HTML> Wed, 06 Nov 2013 10:34:44 GMT https://community.qlik.com/t5/QlikView/Growth-Calculation/m-p/468158#M557614 qlikviewforum 2013-11-06T10:34:44Z