topic What's the expression for delta? in QlikView https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332207#M1171969 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have data similar to this chart. I want to find the delta and i'm not sure how to form the expression in the table. So:</P><P></P><P>Inventory2011 - Inventory 2010 / Revenue2011 - Revenue2010 </P><P></P><P>How can the change over year for EACH company? I already have the expression of Inventory to Revenue along with some other simple ratios. Just not sure how the expression should look.</P><P></P><P>Thanks!</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="252" style="border: 1px solid rgb(0, 0, 0); height: 192px; width: 329px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Revenue<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Inventory <BR /></STRONG></SPAN></TH></TR><TR><TD>Company A</TD><TD>2011</TD><TD>$8</TD><TD>$2</TD></TR><TR><TD>Company A</TD><TD>2010</TD><TD>$10</TD><TD>$1</TD></TR><TR><TD>Company A</TD><TD>2009</TD><TD>$12</TD><TD>$3</TD></TR><TR><TD>Company A</TD><TD>2008</TD><TD>$6</TD><TD>$2</TD></TR><TR><TD>Company A</TD><TD>2007</TD><TD>$13</TD><TD>$2</TD></TR><TR><TD>Company B</TD><TD>2011</TD><TD>$10</TD><TD>$5</TD></TR><TR><TD>Company B</TD><TD>2010</TD><TD>$11</TD><TD>$3</TD></TR><TR><TD>Company B</TD><TD>2009</TD><TD>$9</TD><TD>$2</TD></TR><TR><TD>Company B</TD><TD>2008</TD><TD>$7</TD><TD>$6</TD></TR><TR><TD>Company B</TD><TD>2007</TD><TD>$15</TD><TD>$2</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 03 Jul 2012 16:16:57 GMT 2012-07-03T16:16:57Z What's the expression for delta? https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332207#M1171969 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have data similar to this chart. I want to find the delta and i'm not sure how to form the expression in the table. So:</P><P></P><P>Inventory2011 - Inventory 2010 / Revenue2011 - Revenue2010 </P><P></P><P>How can the change over year for EACH company? I already have the expression of Inventory to Revenue along with some other simple ratios. Just not sure how the expression should look.</P><P></P><P>Thanks!</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="252" style="border: 1px solid rgb(0, 0, 0); height: 192px; width: 329px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Revenue<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Inventory <BR /></STRONG></SPAN></TH></TR><TR><TD>Company A</TD><TD>2011</TD><TD>$8</TD><TD>$2</TD></TR><TR><TD>Company A</TD><TD>2010</TD><TD>$10</TD><TD>$1</TD></TR><TR><TD>Company A</TD><TD>2009</TD><TD>$12</TD><TD>$3</TD></TR><TR><TD>Company A</TD><TD>2008</TD><TD>$6</TD><TD>$2</TD></TR><TR><TD>Company A</TD><TD>2007</TD><TD>$13</TD><TD>$2</TD></TR><TR><TD>Company B</TD><TD>2011</TD><TD>$10</TD><TD>$5</TD></TR><TR><TD>Company B</TD><TD>2010</TD><TD>$11</TD><TD>$3</TD></TR><TR><TD>Company B</TD><TD>2009</TD><TD>$9</TD><TD>$2</TD></TR><TR><TD>Company B</TD><TD>2008</TD><TD>$7</TD><TD>$6</TD></TR><TR><TD>Company B</TD><TD>2007</TD><TD>$15</TD><TD>$2</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 03 Jul 2012 16:16:57 GMT https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332207#M1171969 2012-07-03T16:16:57Z Re: What's the expression for delta? https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332208#M1171970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May this will work?</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Tue, 03 Jul 2012 17:27:57 GMT https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332208#M1171970 2012-07-03T17:27:57Z Re: What's the expression for delta? https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332209#M1171971 <HTML><HEAD></HEAD><BODY><P>Almost. I'm looking for <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Inventory2011 - Inventory 2010 / Revenue2011 - Revenue2010</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">2-1 / 8-10 = -.50%</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">So i just need that one percentage for each company. (only one column that gives me the percentage change over each year)<BR /></SPAN></P></BODY></HTML> Tue, 03 Jul 2012 18:14:39 GMT https://community.qlik.com/t5/QlikView/What-s-the-expression-for-delta/m-p/332209#M1171971 2012-07-03T18:14:39Z