topic Re: Increase or decrease in % in QlikView https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370659#M137824 <HTML><HEAD></HEAD><BODY><P>try this expression for the % Increase/Decrease:</P><P></P><P>=if(Turnover &gt;= above(Turnover)</P><P>,((Turnover/above(Turnover))-1) * 100</P><P>, ((Turnover/above(Turnover))) * -100</P><P>)</P></BODY></HTML> Thu, 26 Apr 2012 17:34:38 GMT mphekin12 2012-04-26T17:34:38Z Increase or decrease in % https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370658#M137823 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dashboard with an example:</P><P></P><P>column1&nbsp;&nbsp;&nbsp; Year </P><P> column2&nbsp;&nbsp; Turnover</P><P> column3&nbsp;&nbsp; % increase or decrease to last year</P><P></P><P>So i want the following table :</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 148pt; border-collapse: collapse;" width="198"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0.5pt solid #bbd192; width: 32pt; height: 12.75pt; background-color: #d1e0b5;" width="43"><STRONG style="font-family: Tahoma;">Year</STRONG></TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: #bbd192 #bbd192 #bbd192 black; width: 50pt; background-color: #d1e0b5;" width="67"><STRONG style="color: #000000; font-family: Tahoma;">TO</STRONG></TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: #bbd192 #bbd192 #bbd192 black; width: 66pt; background-color: #d1e0b5;" width="88"><STRONG style="color: #000000; font-family: Tahoma;">% Increase</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 1pt 0px; border-style: solid none; border-color: #bbd192 black; height: 12.75pt; background-color: #d1e0b5;"><STRONG style="font-family: Tahoma;"> </STRONG></TD><TD class="xl67" style="border-width: 1pt 0.5pt; border-style: solid; border-color: #bbd192; background-color: #d1e0b5;"><STRONG style="color: #000000; font-family: Tahoma;">7320</STRONG></TD><TD class="xl68" style="border-width: 1pt 0.5pt 1pt 0px; border-style: solid solid solid none; border-color: #bbd192 #bbd192 #bbd192 black; background-color: #d1e0b5;"><STRONG style="color: #000000; font-family: Tahoma;"> </STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border: 0.5pt solid #bbd192; height: 12.75pt; background-color: #e7efd9;"><SPAN style="font-family: Tahoma;">2005</SPAN></TD><TD class="xl69" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: #bbd192 #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">1000</SPAN></TD><TD class="xl70" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: #bbd192 #bbd192 #bbd192 black; background-color: #e7efd9;"></TD></TR><TR style="height: 12.75pt;"><TD class="xl71" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black #bbd192 #bbd192; height: 12.75pt; background-color: #d1e0b5;"><SPAN style="font-family: Tahoma;">2006</SPAN></TD><TD class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #d1e0b5;"><SPAN style="color: #000000; font-family: Tahoma;">1010</SPAN></TD><TD align="right" class="xl72" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #d1e0b5;"><SPAN style="color: #000000; font-family: Tahoma;">1</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black #bbd192 #bbd192; height: 12.75pt; background-color: #e7efd9;"><SPAN style="font-family: Tahoma;">2007</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">2020</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl71" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black #bbd192 #bbd192; height: 12.75pt; background-color: #d1e0b5;"><SPAN style="font-family: Tahoma;">2008</SPAN></TD><TD class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #d1e0b5;"><SPAN style="color: #000000; font-family: Tahoma;">1010</SPAN></TD><TD align="right" class="xl72" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #d1e0b5;"><SPAN style="color: #000000; font-family: Tahoma;">-100</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black #bbd192 #bbd192; height: 12.75pt; background-color: #e7efd9;"><SPAN style="font-family: Tahoma;">2009</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">1111</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">10</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl71" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black #bbd192 #bbd192; height: 12.75pt; background-color: #d1e0b5;"><SPAN style="font-family: Tahoma;">2010</SPAN></TD><TD class="xl71" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #d1e0b5;"><SPAN style="color: #000000; font-family: Tahoma;">1111</SPAN></TD><TD align="right" class="xl72" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #d1e0b5;"><SPAN style="color: #000000; font-family: Tahoma;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black #bbd192 #bbd192; height: 12.75pt; background-color: #e7efd9;"><SPAN style="font-family: Tahoma;">2011</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">3333</SPAN></TD><TD align="right" class="xl70" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black #bbd192 #bbd192 black; background-color: #e7efd9;"><SPAN style="color: #000000; font-family: Tahoma;">200</SPAN></TD></TR></TBODY></TABLE><P><BR />Can someone help me</P></BODY></HTML> Thu, 26 Apr 2012 16:59:37 GMT https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370658#M137823 francisvandergr 2012-04-26T16:59:37Z Re: Increase or decrease in % https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370659#M137824 <HTML><HEAD></HEAD><BODY><P>try this expression for the % Increase/Decrease:</P><P></P><P>=if(Turnover &gt;= above(Turnover)</P><P>,((Turnover/above(Turnover))-1) * 100</P><P>, ((Turnover/above(Turnover))) * -100</P><P>)</P></BODY></HTML> Thu, 26 Apr 2012 17:34:38 GMT https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370659#M137824 mphekin12 2012-04-26T17:34:38Z Increase or decrease in % https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370660#M137825 <HTML><HEAD></HEAD><BODY><P>I think (using your expression label TO from your sample, or replace with your expression to calculate the turnover): </P><P></P><P><EM>=(TO-above(TO))/above(TO)</EM></P><P></P><P>could be enough.</P><P>Format percentage in numbers tab, if you like.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 26 Apr 2012 18:26:50 GMT https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370660#M137825 swuehl 2012-04-26T18:26:50Z Re: Increase or decrease in % https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370661#M137826 <HTML><HEAD></HEAD><BODY><P>Stefan,</P><P></P><P>Your solution is much cleaner. Thanks for the suggestion!</P><P></P><P>Mike</P></BODY></HTML> Thu, 26 Apr 2012 18:41:47 GMT https://community.qlik.com/t5/QlikView/Increase-or-decrease-in/m-p/370661#M137826 mphekin12 2012-04-26T18:41:47Z