Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Question about the count-function

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.

1 Solution

Accepted Solutions
Not applicable

Question about the count-function

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

4 Replies
martinpohl
Valued Contributor II

Question about the count-function

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.

Not applicable

Question about the count-function

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

Not applicable

Question about the count-function

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)

Not applicable

Question about the count-function

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