topic Re: Need a help to calculate Accuracy in QlikView https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912763#M986468 <HTML><HEAD></HEAD><BODY><P>please post your data</P></BODY></HTML> Wed, 05 Aug 2015 18:18:20 GMT sasiparupudi1 2015-08-05T18:18:20Z Need a help to calculate Accuracy https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912761#M986466 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>Attached is the data...</P><P></P><P>I want to create line chart by using expression 1-(fabs([Quantity])/[Real Qty]) and dimension is Date.</P><P></P><P>But I am Unable to see the values</P><P>I am getting output as following</P><P></P><P><IMG alt="Dash.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95097_Dash.JPG" style="height: auto;" /></P><P></P><P>Result should be in percentage.. Here I am getting output. it's displaying only 100% I want to show all the data.</P><P></P><P>Could any one one help how to resolve this issue. It's Really Needful</P><P></P><P>Thank you,</P><P>Satya Paleti</P></BODY></HTML> Wed, 05 Aug 2015 17:29:38 GMT https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912761#M986466 SatyaPaleti 2015-08-05T17:29:38Z Re: Need a help to calculate Accuracy https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912762#M986467 <HTML><HEAD></HEAD><BODY><P>Maybe is related to your data, it would be easier to help with some sample of your app</P></BODY></HTML> Wed, 05 Aug 2015 17:32:06 GMT https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912762#M986467 Clever_Anjos 2015-08-05T17:32:06Z Re: Need a help to calculate Accuracy https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912763#M986468 <HTML><HEAD></HEAD><BODY><P>please post your data</P></BODY></HTML> Wed, 05 Aug 2015 18:18:20 GMT https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912763#M986468 sasiparupudi1 2015-08-05T18:18:20Z Re: Need a help to calculate Accuracy https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912764#M986469 <HTML><HEAD></HEAD><BODY><P>Please post the sample.</P><P></P><P>Perhaps you can try</P><P></P><P>Use expression - num(fabs(sum([Quantity]))/sum([Real Qty]),'##.00%')</P></BODY></HTML> Wed, 05 Aug 2015 18:23:24 GMT https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912764#M986469 Kushal_Chawda 2015-08-05T18:23:24Z Re: Need a help to calculate Accuracy https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912765#M986470 <HTML><HEAD></HEAD><BODY><P>Try the below one</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">1-(Sum(fabs([Quantity]))/Sum([Real Qty]))</SPAN></P></BODY></HTML> Wed, 05 Aug 2015 18:35:57 GMT https://community.qlik.com/t5/QlikView/Need-a-help-to-calculate-Accuracy/m-p/912765#M986470 CELAMBARASAN 2015-08-05T18:35:57Z