Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
try below expression, hope it help.
count(distinct {<LINEHAUL_GROSS={'>0'}>}[Trailer Num])/ count ( distinct total [Trailer Num] )
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
Thanks, This worked.