topic Re: Showing the percentage difference in QlikView https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848115#M1001276 <HTML><HEAD></HEAD><BODY><P>A small modification to Manish file. Still, not exactly as you wanted.</P></BODY></HTML> Thu, 18 Jun 2015 07:54:31 GMT daniel_kusiak 2015-06-18T07:54:31Z Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848104#M1001265 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>How to achieve the ((2014 SAL-<SPAN style="font-size: 13.3333330154419px;">2015 SAL)/<SPAN style="font-size: 13.3333330154419px;">2014 SAL)*100 for each JOB as shown in table and graph.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Thanks in advance.</SPAN></P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 425px;"><TBODY><TR><TD class="xl65" height="17" width="98"><STRONG>Year</STRONG></TD><TD class="xl65" style="border-left: none;" width="98"><STRONG>JOB</STRONG></TD><TD align="right" class="xl65" style="border-left: none;" width="98"><STRONG>2014</STRONG></TD><TD align="right" class="xl65" style="border-left: none;" width="64"><STRONG>2015</STRONG></TD><TD class="xl66" style="border-left: none;" width="67"><STRONG>SAL %</STRONG></TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">ANALYST</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">33.33</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">CLERK</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3950</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4150</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">-4.82</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">MANAGER</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">11275</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">7275</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">54.98</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">PRESIDENT</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5000</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20.00</TD></TR><TR><TD align="right" class="xl65" height="17" style="border-top: none;">2014</TD><TD class="xl65" style="border-top: none; border-left: none;">SALESMAN</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">8300</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5600</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">48.21</TD></TR></TBODY></TABLE><P></P><P>How to show as shown the graph. Please find the attached application.</P><P><IMG __jive_id="89868" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89868_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848104#M1001265 qlikviewwizard 2020-11-20T18:02:30Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848105#M1001266 <HTML><HEAD></HEAD><BODY><P>Use Barr Offset to achieve this.</P></BODY></HTML> Thu, 18 Jun 2015 05:50:35 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848105#M1001266 sujeetsingh 2015-06-18T05:50:35Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848106#M1001267 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/sujeetsingh">sujeetsingh</A>,</STRONG>Could you attach the file, please .</P></BODY></HTML> Thu, 18 Jun 2015 05:52:48 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848106#M1001267 qlikviewwizard 2015-06-18T05:52:48Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848107#M1001268 <HTML><HEAD></HEAD><BODY><P>HI PLease find the attachment</P></BODY></HTML> Thu, 18 Jun 2015 05:59:29 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848107#M1001268 smilingjohn 2015-06-18T05:59:29Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848108#M1001269 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/smilingjohn">smilingjohn</A></STRONG></P><P>There is no attachment.<STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P></BODY></HTML> Thu, 18 Jun 2015 06:00:39 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848108#M1001269 qlikviewwizard 2015-06-18T06:00:39Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848109#M1001270 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/smilingjohn">smilingjohn</A></STRONG>,</P><P>My requirement is like this:</P><P>For eg:</P><P>I want to show JOB ANALYST 33.33% as hwon below screen.</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89870_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 18 Jun 2015 06:05:06 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848109#M1001270 qlikviewwizard 2015-06-18T06:05:06Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848110#M1001271 <HTML><HEAD></HEAD><BODY><P>Check this..</P></BODY></HTML> Thu, 18 Jun 2015 06:05:35 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848110#M1001271 MK_QSL 2015-06-18T06:05:35Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848111#M1001272 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/MRKachhiaIMP">MRKachhiaIMP</A></STRONG></P><P>Excellent. Many thanks.</P></BODY></HTML> Thu, 18 Jun 2015 06:09:51 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848111#M1001272 qlikviewwizard 2015-06-18T06:09:51Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848112#M1001273 <HTML><HEAD></HEAD><BODY><P>Attached is the solution</P></BODY></HTML> Thu, 18 Jun 2015 06:10:39 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848112#M1001273 svenkita 2015-06-18T06:10:39Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848113#M1001274 <HTML><HEAD></HEAD><BODY><P>Any other solutions please.</P></BODY></HTML> Thu, 18 Jun 2015 06:52:57 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848113#M1001274 qlikviewwizard 2015-06-18T06:52:57Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848114#M1001275 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Thu, 18 Jun 2015 06:56:07 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848114#M1001275 2015-06-18T06:56:07Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848115#M1001276 <HTML><HEAD></HEAD><BODY><P>A small modification to Manish file. Still, not exactly as you wanted.</P></BODY></HTML> Thu, 18 Jun 2015 07:54:31 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848115#M1001276 daniel_kusiak 2015-06-18T07:54:31Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848116#M1001277 <HTML><HEAD></HEAD><BODY><P>See attached file</P></BODY></HTML> Thu, 18 Jun 2015 08:19:54 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848116#M1001277 qlikmsg4u 2015-06-18T08:19:54Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848117#M1001278 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/Daniel_Kusiak">Daniel_Kusiak</A></STRONG></P><P>Thank you for the reply.</P><P>I am getting the output like this.&nbsp; Please help for the attached files.</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89889_Capture.JPG" style="height: 232px; width: 620px;" /></P></BODY></HTML> Thu, 18 Jun 2015 09:13:32 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848117#M1001278 qlikviewwizard 2015-06-18T09:13:32Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848118#M1001279 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="89890" alt="" class="jive-image image-1" height="395" src="https://community.qlik.com/legacyfs/online/89890_pastedImage_0.png" style="max-width: 1200px; max-height: 900px; height: 395px; width: 609.799px;" width="610" /></P><P></P><P>For me it looks like that.</P></BODY></HTML> Thu, 18 Jun 2015 09:19:27 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848118#M1001279 daniel_kusiak 2015-06-18T09:19:27Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848119#M1001280 <HTML><HEAD></HEAD><BODY><P>FOr me 3rd one is not showing. What may be the reason? Am I missing something?</P></BODY></HTML> Thu, 18 Jun 2015 09:29:59 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848119#M1001280 qlikviewwizard 2015-06-18T09:29:59Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848120#M1001281 <HTML><HEAD></HEAD><BODY><P>You didn't set the Bar Offset. Look at the attached file now.</P></BODY></HTML> Thu, 18 Jun 2015 09:45:52 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848120#M1001281 daniel_kusiak 2015-06-18T09:45:52Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848121#M1001282 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/Daniel_Kusiak">Daniel_Kusiak</A></STRONG>,</P><P>Very strange. I have done the same but not succeeded.</P><P>Could you tell me which option/settings need to do?</P></BODY></HTML> Thu, 18 Jun 2015 11:08:51 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848121#M1001282 qlikviewwizard 2015-06-18T11:08:51Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848122#M1001283 <HTML><HEAD></HEAD><BODY><P>As I said before you didn't set the Bar Offset.</P><P></P><P><IMG alt="" class="jive-image image-1" height="379" src="https://community.qlik.com/legacyfs/online/89925_pastedImage_1.png" style="width: 508px; height: 378.542px;" width="508" /></P></BODY></HTML> Thu, 18 Jun 2015 11:23:29 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848122#M1001283 daniel_kusiak 2015-06-18T11:23:29Z Re: Showing the percentage difference https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848123#M1001284 <HTML><HEAD></HEAD><BODY><P>Thank you all for wonderful answers.</P></BODY></HTML> Thu, 18 Jun 2015 13:12:31 GMT https://community.qlik.com/t5/QlikView/Showing-the-percentage-difference/m-p/848123#M1001284 qlikviewwizard 2015-06-18T13:12:31Z