topic Question about the count-function in QlikView

Question about the count-function

Fri, 18 Nov 2011 11:22:32 GMT

Hi,

I want to count all rows of an column where the value is 1. I have tried it with the count-function:

count(column(2)=1)

But it shows me just the number of all rows of the column. How can I create a formula that shows me the right value?

Thank you for your help.

martinpohl — Fri, 18 Nov 2011 12:12:52 GMT

Hello,

the problem is that the result of column(2) is in each line.

So if you want to count where do want to count?

In the title of the chart? In a textbox?

Regards.

Fri, 18 Nov 2011 12:18:09 GMT

I have got a table and I want the result in a diagram.

Fri, 18 Nov 2011 12:38:51 GMT

Maybe this won't fit your requirements if its grander than your example but a simple fix could be within your script.

If(column2=1,1,0) as Column2_1Count

then sum(Column2_1Count)

Fri, 18 Nov 2011 13:20:57 GMT

Sum(if((column(2)=1,1,0)