https://community.qlik.com/t5/QlikView/Mathematical-Calculation/m-p/1888732#M1217183 <P>I completed this using the below expression in the text box.</P> <P><SPAN data-contrast="auto">=Count(distinct{&lt;Fail = {1}&gt;}Label) &amp; ' / ' &amp;Count(distinct Label)</SPAN></P> Thu, 03 Feb 2022 14:43:25 GMT nigharikkha 2022-02-03T14:43:25Z https://community.qlik.com/t5/QlikView/Mathematical-Calculation/m-p/1888708#M1217179 <P>Hi&nbsp;</P> <P>I have a table with fields as shown below (sample data).</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nigharikkha_0-1643897179299.png" style="width: 295px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71541i8B9C13CB37899A9B/image-dimensions/295x176?v=v2" width="295" height="176" role="button" title="nigharikkha_0-1643897179299.png" alt="nigharikkha_0-1643897179299.png" /></span></P> <P>I need to calculate the failure rate and display in the text box.</P> <P>Failure Rate = (Number of distinct Label with Fail=1) / Number of distinct Label</P> <P>In this example,&nbsp;Number of distinct Label with Fail=1 is 1 and&nbsp;Number of distinct Label is 2.</P> <P>Please help with the expression for this.</P> Thu, 03 Feb 2022 14:09:32 GMT https://community.qlik.com/t5/QlikView/Mathematical-Calculation/m-p/1888708#M1217179 nigharikkha 2022-02-03T14:09:32Z https://community.qlik.com/t5/QlikView/Mathematical-Calculation/m-p/1888732#M1217183 <P>I completed this using the below expression in the text box.</P> <P><SPAN data-contrast="auto">=Count(distinct{&lt;Fail = {1}&gt;}Label) &amp; ' / ' &amp;Count(distinct Label)</SPAN></P> Thu, 03 Feb 2022 14:43:25 GMT https://community.qlik.com/t5/QlikView/Mathematical-Calculation/m-p/1888732#M1217183 nigharikkha 2022-02-03T14:43:25Z