Count If

[QlikSenseUser2]

I'm trying to write a function that will divide the count of the Trailer Num with a  LINEHAUL_GROSS> 0  by the total count of the Trailer Num.

[durgesh22]

try below expression, hope it help.

count(distinct {<LINEHAUL_GROSS={'>0'}>}[Trailer Num])/ count ( distinct  total [Trailer Num] )

[vinieme12 · Accepted solution]

As below

count( {<[Trailer Num]={"=sum(LINEHAUL_GROSS)>0"}>} DISTINCT [Trailer Num])/ count ( distinct  total [Trailer Num] )

Refer this blog for more 

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907

[QlikSenseUser2]

Thanks, This worked.