topic Sum of Count in QlikView

Sum of Count

andyrebs — Fri, 08 Jun 2012 15:16:21 GMT

I have a problem, I know that it is very simple, but it's Friday and I can't get out of this little trouble.

I know the Count function, what is the correct expression to have the total of counts. To be more clear I would like to have a percentage (count(field)/sum of count(field). The field is a text field

Thanks again.

Andrea

Sum of Count

swuehl — Fri, 08 Jun 2012 15:19:51 GMT

I assume you are using this expression in a chart object with a dimension.

To disregard the current line dimension value, you can add TOTAL qualifier to your count() function

=count(field) / count(TOTAL field)

TOTAL qualifier can also be used with field list, like TOTAL<DIM1,DIM2>, see the Help for more detail.

Sum of Count

andyrebs — Fri, 08 Jun 2012 15:34:30 GMT

I knew it was simple, I forgot TOTAL.

I use this expression in a list box, if it is possible I would like to transform the expression in a bar chart, do you know how I can set it.

Anyway Thank you.

Andrea

Sum of Count

swuehl — Fri, 08 Jun 2012 15:40:55 GMT

Well, if you are using field as field in your listbox and above expression, I would just try field as dimension in a bar chart and the above expression as expression.

Sum of Count

andyrebs — Fri, 08 Jun 2012 15:47:29 GMT

Thank you, I will check.