topic Re: YOY% Inc in QlikView https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295700#M828646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp; Use below expr you will get solution:-</P><P></P><P>num((sum(Sales)-above(sum(Sales)))/above(sum(Sales)),'##.## %')</P><P></P><P>Regards,</P></BODY></HTML> Thu, 29 Jun 2017 04:25:07 GMT pathiqvd 2017-06-29T04:25:07Z YOY% Inc https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295697#M828643 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>Kindly advise how to compute YOY% increase by products.</P><P></P><P>Correct Answer should be as follow :</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="414"><TBODY><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: white;" width="94"><SPAN style="color: #333333; font-family: Tahoma;">Product</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: white;" width="110"><SPAN style="color: #333333; font-family: Tahoma;">Year</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: white;" width="105"><SPAN style="color: #333333; font-family: Tahoma;">$</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: white;" width="105"><SPAN style="color: #333333; font-family: Tahoma;">YOY%</SPAN></TD></TR><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">A10884</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">2015</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">23000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0%</SPAN></TD></TR><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">A10884</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">2016</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">18000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-22%</SPAN></TD></TR><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">A10884</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">2017</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">15000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">-17%</SPAN></TD></TR><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">B64592</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">2015</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">17000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0%</SPAN></TD></TR><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">B64592</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">2016</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">24000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">41%</SPAN></TD></TR><TR><TD height="20" style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">B64592</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">2017</SPAN></TD><TD style="border: 0px #333333; border-image: none; background-color: #ccffff;"><SPAN style="color: #333333; font-family: Tahoma;">32000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33%</SPAN></TD></TR></TBODY></TABLE><P></P><P>Thank You</P><P>Tracy</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295697#M828643 tracycrown 2020-11-25T16:16:04Z Re: YOY% Inc https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295698#M828644 <HTML><HEAD></HEAD><BODY><P>Hi Tracy,</P><P>see Attachment,</P><P>Regards,</P><P>Antonio.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168512_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 29 Jun 2017 04:10:32 GMT https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295698#M828644 antoniotiman 2017-06-29T04:10:32Z Re: YOY% Inc https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295699#M828645 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 29 Jun 2017 04:18:07 GMT https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295699#M828645 prma7799 2017-06-29T04:18:07Z Re: YOY% Inc https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295700#M828646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp; Use below expr you will get solution:-</P><P></P><P>num((sum(Sales)-above(sum(Sales)))/above(sum(Sales)),'##.## %')</P><P></P><P>Regards,</P></BODY></HTML> Thu, 29 Jun 2017 04:25:07 GMT https://community.qlik.com/t5/QlikView/YOY-Inc/m-p/1295700#M828646 pathiqvd 2017-06-29T04:25:07Z