Hi ,
I was kindly provided the following expression which helps count certain records:
=Count( {<[SMT]={"Yes"}>} [Sex])
however, we also need to show this as a %. I have the following expression which works fine in a straight table; however we want it in a list box. Qlikview says is ok but isn't producing the correct %. Can anyone please help?
=Count( {<[SMT]={"Yes"}>} [Sex])/Count(TOTAL [SMT])
Chris
