topic Re: Graphic Error Percentage in QlikView https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808392#M1035734 <HTML><HEAD></HEAD><BODY><P>Oh yes!</P><P>Can you check the attachment?</P><P></P><P>PS: maybe replace &lt;100% with <STRONG>-1</STRONG> in my expression, in order to be coherent with other % values... sorry.</P></BODY></HTML> Sun, 18 Jan 2015 15:27:44 GMT Anonymous 2015-01-18T15:27:44Z Graphic Error Percentage https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808389#M1035729 <HTML><HEAD></HEAD><BODY><P style="background: white;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Hi!</SPAN></P><P></P><P style="background: white;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">I'm trying to create a graphic of trend of costs in each month, where:</SPAN></P><P></P><OL style="list-style-type: decimal; direction: ltr;"><LI style="font-style: normal; font-weight: normal;"><P style="background: white; font-style: normal; font-weight: normal; mso-list: l0 level1 lfo1;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Column 1 reports costs for each month of 2011;</SPAN></P></LI><LI style="color: #3d3d3d; font-family: 'Times New Roman','serif'; font-size: 12pt; font-style: normal; font-weight: normal;"><P style="background: white; color: #000000; font-family: 'Times New Roman','serif'; font-size: 12pt; font-style: normal; font-weight: normal; mso-list: l0 level1 lfo1;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Column 2 reports costs for each month of 2012;</SPAN></P></LI><LI style="color: #3d3d3d; font-family: 'Times New Roman','serif'; font-size: 12pt; font-style: normal; font-weight: normal;"><P style="background: white; color: #000000; font-family: 'Times New Roman','serif'; font-size: 12pt; font-style: normal; font-weight: normal; mso-list: l0 level1 lfo1;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Column 3 reports the difference between costs of 2011 and 2012;</SPAN></P></LI><LI style="color: #3d3d3d; font-family: 'Times New Roman','serif'; font-size: 12pt; font-style: normal; font-weight: normal;"><P style="background: white; color: #000000; font-family: 'Times New Roman','serif'; font-size: 12pt; font-style: normal; font-weight: normal; mso-list: l0 level1 lfo1;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Column 4 reports the difference between costs of 2011 and 2012 in percentage;</SPAN></P></LI></OL><P></P><P style="background: white;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">When cost of 2012 is null, I'd like to show the cost has decreased by 100%.</SPAN></P><P style="background: white;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Can anybody help me to fix my expression? Maybe with the example attached.</SPAN></P><P></P><P style="background: white;"><SPAN lang="EN-US" style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt; mso-ansi-language: EN-US;">Thank you for any help you can provide in this situation.</SPAN></P><P></P><P style="background: white;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt;">Regards,</SPAN></P><P></P><P style="background: white; min-height: 8pt;"></P><P></P><P style="background: white;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica','sans-serif'; font-size: 10pt;">Andrea</SPAN></P></BODY></HTML> Sun, 18 Jan 2015 13:57:44 GMT https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808389#M1035729 2015-01-18T13:57:44Z Re: Graphic Error Percentage https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808390#M1035730 <HTML><HEAD></HEAD><BODY><P>Hello Andrea!</P><P>Why doesn't it work?</P><P>If 2012 is 0 the ratio 2011/2012 it is impossible to be calcuated.</P><P>What would you like to display?</P></BODY></HTML> Sun, 18 Jan 2015 14:14:03 GMT https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808390#M1035730 Anonymous 2015-01-18T14:14:03Z Re: Graphic Error Percentage https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808391#M1035732 <HTML><HEAD></HEAD><BODY><P>Hi Elena,</P><P>I'd like to show the cost has decreased by 100%.</P><P>Thank you for your help!</P></BODY></HTML> Sun, 18 Jan 2015 15:02:04 GMT https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808391#M1035732 2015-01-18T15:02:04Z Re: Graphic Error Percentage https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808392#M1035734 <HTML><HEAD></HEAD><BODY><P>Oh yes!</P><P>Can you check the attachment?</P><P></P><P>PS: maybe replace &lt;100% with <STRONG>-1</STRONG> in my expression, in order to be coherent with other % values... sorry.</P></BODY></HTML> Sun, 18 Jan 2015 15:27:44 GMT https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808392#M1035734 Anonymous 2015-01-18T15:27:44Z Re: Graphic Error Percentage https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808393#M1035735 <HTML><HEAD></HEAD><BODY><P>Thank you for your help!</P></BODY></HTML> Sun, 18 Jan 2015 18:16:20 GMT https://community.qlik.com/t5/QlikView/Graphic-Error-Percentage/m-p/808393#M1035735 2015-01-18T18:16:20Z