topic Re: Count If in App Development https://community.qlik.com/t5/App-Development/Count-If/m-p/1929240#M76503 <P>Thanks, This worked.</P> Wed, 11 May 2022 13:08:31 GMT QlikSenseUser2 2022-05-11T13:08:31Z Count If https://community.qlik.com/t5/App-Development/Count-If/m-p/1928596#M76459 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QlikSenseUser2_0-1652187185768.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/79077i9ED688F5DC5FB3D2/image-size/medium?v=v2&amp;px=400" role="button" title="QlikSenseUser2_0-1652187185768.png" alt="QlikSenseUser2_0-1652187185768.png" /></span></P> <P>&nbsp;</P> <P>I'm trying to write a f<SPAN>unction</SPAN><SPAN>&nbsp;that will divide the count of the Trailer Num with a&nbsp; LINEHAUL_GROSS&gt; 0&nbsp; by the total count of the Trailer Num.</SPAN></P> Tue, 10 May 2022 13:05:00 GMT https://community.qlik.com/t5/App-Development/Count-If/m-p/1928596#M76459 QlikSenseUser2 2022-05-10T13:05:00Z Re: Count If https://community.qlik.com/t5/App-Development/Count-If/m-p/1928613#M76460 <P>try below expression, hope it help.</P> <P>count(distinct {&lt;<SPAN>LINEHAUL_GROSS</SPAN>={'&gt;0'}&gt;}[<SPAN>Trailer Num]</SPAN>)/ count ( distinct&nbsp; total [<SPAN>Trailer Num]&nbsp;</SPAN>)</P> Tue, 10 May 2022 13:40:26 GMT https://community.qlik.com/t5/App-Development/Count-If/m-p/1928613#M76460 durgesh22 2022-05-10T13:40:26Z Re: Count If https://community.qlik.com/t5/App-Development/Count-If/m-p/1928882#M76479 <P><SPAN>As below</SPAN></P> <P><SPAN>count( {&lt;[Trailer Num]</SPAN><SPAN>={"=sum(LINEHAUL_GROSS)&gt;0"}&gt;} DISTINCT [</SPAN><SPAN>Trailer Num]</SPAN><SPAN>)/ count ( distinct&nbsp; total [</SPAN><SPAN>Trailer Num]&nbsp;</SPAN><SPAN>)</SPAN></P> <P>&nbsp;</P> <P><SPAN>Refer this blog for more&nbsp;</SPAN></P> <P><SPAN><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907</A></SPAN></P> <P><SPAN>&nbsp;</SPAN></P> Wed, 11 May 2022 02:58:39 GMT https://community.qlik.com/t5/App-Development/Count-If/m-p/1928882#M76479 vinieme12 2022-05-11T02:58:39Z Re: Count If https://community.qlik.com/t5/App-Development/Count-If/m-p/1929240#M76503 <P>Thanks, This worked.</P> Wed, 11 May 2022 13:08:31 GMT https://community.qlik.com/t5/App-Development/Count-If/m-p/1929240#M76503 QlikSenseUser2 2022-05-11T13:08:31Z