Discussion board where members can get started with QlikView.
I want to count all rows of an column where the value is 1. I have tried it with the count-function:
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.
Go to Solution.
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?
I have got a table and I want the result in a diagram.
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