expression help

Fri, 04 Sep 2015 09:07:04 GMT

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

Re: expression help

Gysbert_Wassenaar — Fri, 04 Sep 2015 12:57:40 GMT

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)

topic Re: expression help in QlikView

expression help

Re: expression help