expression help

[#1]

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

[Gysbert_Wassenaar]

Try that expression in a text box. You'll see that without a dimension it will return a single value. For a listbox you need a list of values. You can try using an expression with the Aggr function: =aggr(Count( {<[SMT]={"Yes"}>} [Sex])/Count(TOTAL [SMT]), MyDimensionHere)