topic Re: how can i use count if in QlikView https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376880#M459398 <HTML><HEAD></HEAD><BODY><P>As <A href="https://community.qlik.com/people/sergio0592">sergio0592</A>‌ set analysis is the way to go for these kind of questions, but in case you want to learn the if syntax... it would look like this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>Count(DISTINCT If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">STATUS_EXCP_CODE = 'sent',</SPAN> TRACK_NO))</STRONG></SPAN></P></BODY></HTML> Sun, 01 Oct 2017 22:21:29 GMT sunny_talwar 2017-10-01T22:21:29Z how can i use count if https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376878#M459396 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">hello</P><P style="font-size: 13.3333px;">i'm a new user of qlik.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i want to&nbsp; count&nbsp; how mach track_no have status "sent"</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">countcount(distinct TRACK_NO) if (<SPAN style="font-size: 10pt;">STATUS_EXCP_CODE = 'sent)</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">what is the correct syntax?</SPAN></P></BODY></HTML> Sun, 01 Oct 2017 13:04:44 GMT https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376878#M459396 y_vandijk 2017-10-01T13:04:44Z Re: how can i use count if https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376879#M459397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use a set analysis with:</P><P></P><P>count({$&lt;<SPAN style="font-size: 10pt;">STATUS_EXCP_CODE = {"sent"}</SPAN> &gt;}&nbsp;&nbsp;&nbsp; distinct TRACK_NO)&nbsp; </P></BODY></HTML> Sun, 01 Oct 2017 20:48:57 GMT https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376879#M459397 sergio0592 2017-10-01T20:48:57Z Re: how can i use count if https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376880#M459398 <HTML><HEAD></HEAD><BODY><P>As <A href="https://community.qlik.com/people/sergio0592">sergio0592</A>‌ set analysis is the way to go for these kind of questions, but in case you want to learn the if syntax... it would look like this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>Count(DISTINCT If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">STATUS_EXCP_CODE = 'sent',</SPAN> TRACK_NO))</STRONG></SPAN></P></BODY></HTML> Sun, 01 Oct 2017 22:21:29 GMT https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376880#M459398 sunny_talwar 2017-10-01T22:21:29Z Re: how can i use count if https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376881#M459399 <HTML><HEAD></HEAD><BODY><P>thanks you very much !!!</P><P></P><P>it is working</P></BODY></HTML> Mon, 02 Oct 2017 03:38:06 GMT https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376881#M459399 y_vandijk 2017-10-02T03:38:06Z Re: how can i use count if https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376882#M459400 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">thanks you very much !!!</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">it is working</P></BODY></HTML> Mon, 02 Oct 2017 03:38:31 GMT https://community.qlik.com/t5/QlikView/how-can-i-use-count-if/m-p/1376882#M459400 y_vandijk 2017-10-02T03:38:31Z