https://community.qlik.com/t5/QlikView/Count-a-column-depending-of-its-value/m-p/1590637#M443542 <P>Hi, I am trying to count how many 1s are there for&nbsp; each value of column GSD_SA</P><P>I should get for X&nbsp; a value of 3</P><P>and I should get&nbsp; for Y a value of&nbsp; 6</P><P>I am using&nbsp; &nbsp; &nbsp;<STRONG>count({&lt;UNDER_25={'1'}&gt;} GSD_SA_ID)&nbsp;</STRONG> &nbsp; &nbsp;but I am getting a weird result. Ideas?</P><P>GSD_ACCT_ID&nbsp; &nbsp; &nbsp;GSD_SA_ID&nbsp; &nbsp; &nbsp;UNDER_25</P><TABLE><TBODY><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>1</TD></TR><TR><TD>1</TD><TD>X</TD><TD>1</TD></TR><TR><TD>1</TD><TD>X</TD><TD>1</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR></TBODY></TABLE> Tue, 11 Jun 2019 19:37:49 GMT machm384 2019-06-11T19:37:49Z https://community.qlik.com/t5/QlikView/Count-a-column-depending-of-its-value/m-p/1590637#M443542 <P>Hi, I am trying to count how many 1s are there for&nbsp; each value of column GSD_SA</P><P>I should get for X&nbsp; a value of 3</P><P>and I should get&nbsp; for Y a value of&nbsp; 6</P><P>I am using&nbsp; &nbsp; &nbsp;<STRONG>count({&lt;UNDER_25={'1'}&gt;} GSD_SA_ID)&nbsp;</STRONG> &nbsp; &nbsp;but I am getting a weird result. Ideas?</P><P>GSD_ACCT_ID&nbsp; &nbsp; &nbsp;GSD_SA_ID&nbsp; &nbsp; &nbsp;UNDER_25</P><TABLE><TBODY><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>1</TD></TR><TR><TD>1</TD><TD>X</TD><TD>1</TD></TR><TR><TD>1</TD><TD>X</TD><TD>1</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>1</TD><TD>X</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR><TR><TD>2</TD><TD>Y</TD><TD>0</TD></TR></TBODY></TABLE> Tue, 11 Jun 2019 19:37:49 GMT https://community.qlik.com/t5/QlikView/Count-a-column-depending-of-its-value/m-p/1590637#M443542 machm384 2019-06-11T19:37:49Z https://community.qlik.com/t5/QlikView/Count-a-column-depending-of-its-value/m-p/1590639#M443543 <P>Have you just tried Sum(UNDER_25)?</P> Tue, 11 Jun 2019 19:40:58 GMT https://community.qlik.com/t5/QlikView/Count-a-column-depending-of-its-value/m-p/1590639#M443543 sunny_talwar 2019-06-11T19:40:58Z