topic Calculating % 2012 vs 2011 in QlikView https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426668#M490299 <HTML><HEAD></HEAD><BODY><P>I have 2 expressions<SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">={2011}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Billed Amount USD]</SPAN><SPAN style="font-size: 8pt;">) <SPAN style="font-size: 10pt;">and</SPAN> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">={2012}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Billed Amount USD<SPAN style="font-size: 10pt;">]</SPAN></SPAN><SPAN style="font-size: 8pt;">), <SPAN style="font-size: 10pt;">how can i calculate the % that expresses 2012 vs 2011? </SPAN></SPAN></P></BODY></HTML> Thu, 18 Oct 2012 09:43:22 GMT 2012-10-18T09:43:22Z Calculating % 2012 vs 2011 https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426668#M490299 <HTML><HEAD></HEAD><BODY><P>I have 2 expressions<SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">={2011}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Billed Amount USD]</SPAN><SPAN style="font-size: 8pt;">) <SPAN style="font-size: 10pt;">and</SPAN> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">={2012}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Billed Amount USD<SPAN style="font-size: 10pt;">]</SPAN></SPAN><SPAN style="font-size: 8pt;">), <SPAN style="font-size: 10pt;">how can i calculate the % that expresses 2012 vs 2011? </SPAN></SPAN></P></BODY></HTML> Thu, 18 Oct 2012 09:43:22 GMT https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426668#M490299 2012-10-18T09:43:22Z Re: Calculating % 2012 vs 2011 https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426669#M490300 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The % increase could be expressed:</P><P></P><P>(sum({$&lt;Year={2012}&gt;}[Billed Amount USD]) - sum({$&lt;Year={2011}&gt;}[Billed Amount USD])) / sum({$&lt;Year={2011}&gt;}[Billed Amount USD])</P><P></P><P>Hope that helps</P><P>Jonathan</P><P></P><P>PS: Check the display as % option on the number tab of the chart proprties</P></BODY></HTML> Thu, 18 Oct 2012 09:49:14 GMT https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426669#M490300 jonathandienst 2012-10-18T09:49:14Z Re: Calculating % 2012 vs 2011 https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426670#M490301 <HTML><HEAD></HEAD><BODY><P>hai,</P><P></P><P>use (current-previous/current )&nbsp; and use relative option&nbsp;&nbsp; in straight table&nbsp; so you will get the variance.</P><P></P><P>see the attachment</P></BODY></HTML> Thu, 18 Oct 2012 09:51:13 GMT https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426670#M490301 2012-10-18T09:51:13Z Re: Calculating % 2012 vs 2011 https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426671#M490302 <HTML><HEAD></HEAD><BODY><P>Got it, thanks!</P></BODY></HTML> Thu, 18 Oct 2012 10:33:59 GMT https://community.qlik.com/t5/QlikView/Calculating-2012-vs-2011/m-p/426671#M490302 2012-10-18T10:33:59Z