topic Calculating Percentage from two expressions in QlikView https://community.qlik.com/t5/QlikView/Calculating-Percentage-from-two-expressions/m-p/407854#M570632 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two separate expressions as below:</P><P></P><P><STRONG>=count(callref), </STRONG>which gives me the total amount of calls.</P><P>=<STRONG>count({$&lt;[withinfix]={0}&gt;} withinfix)</STRONG>, which gives me the total amount of calls where field <STRONG>withinfix </STRONG>equals 0.</P><P></P><P>What I am looking to do is create and expression in a <STRONG>text box </STRONG>to show the percentage between the field with the total amount of calls and the field where withinfix equals 0.</P><P></P><P>I have tried the below expression with no luck.&nbsp; Would someone be able to help please?</P><P></P><P>=sum(count(callref) / (count({$&lt;[withinfix]={0}&gt;} withinfix))) * 100</P><P></P><P>However this shows a NULL Value.</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Fri, 12 Oct 2012 10:46:34 GMT 2012-10-12T10:46:34Z Calculating Percentage from two expressions https://community.qlik.com/t5/QlikView/Calculating-Percentage-from-two-expressions/m-p/407854#M570632 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two separate expressions as below:</P><P></P><P><STRONG>=count(callref), </STRONG>which gives me the total amount of calls.</P><P>=<STRONG>count({$&lt;[withinfix]={0}&gt;} withinfix)</STRONG>, which gives me the total amount of calls where field <STRONG>withinfix </STRONG>equals 0.</P><P></P><P>What I am looking to do is create and expression in a <STRONG>text box </STRONG>to show the percentage between the field with the total amount of calls and the field where withinfix equals 0.</P><P></P><P>I have tried the below expression with no luck.&nbsp; Would someone be able to help please?</P><P></P><P>=sum(count(callref) / (count({$&lt;[withinfix]={0}&gt;} withinfix))) * 100</P><P></P><P>However this shows a NULL Value.</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Fri, 12 Oct 2012 10:46:34 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage-from-two-expressions/m-p/407854#M570632 2012-10-12T10:46:34Z Re: Calculating Percentage from two expressions https://community.qlik.com/t5/QlikView/Calculating-Percentage-from-two-expressions/m-p/407855#M570633 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please dont waste your time on this one, I have managed to figure it out.</P><P></P><P>The calculation is: =count([$&lt;[withinfix]={0}&gt;} withinfix) / count(callref) * 100</P></BODY></HTML> Fri, 12 Oct 2012 11:11:51 GMT https://community.qlik.com/t5/QlikView/Calculating-Percentage-from-two-expressions/m-p/407855#M570633 2012-10-12T11:11:51Z