topic Re: Distinct Count on Row in QlikView https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592603#M478804 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>Count(Distinct RowID)</P></BODY></HTML> Mon, 03 Mar 2014 11:02:57 GMT MayilVahanan 2014-03-03T11:02:57Z Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592602#M478803 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>How can i do a distinctcount on RowID. </P><P></P><P>Thanks</P></BODY></HTML> Mon, 03 Mar 2014 11:00:58 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592602#M478803 2014-03-03T11:00:58Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592603#M478804 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>Count(Distinct RowID)</P></BODY></HTML> Mon, 03 Mar 2014 11:02:57 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592603#M478804 MayilVahanan 2014-03-03T11:02:57Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592604#M478805 <HTML><HEAD></HEAD><BODY><P>in the script:</P><P></P><P>select count distinct RowId from ...</P></BODY></HTML> Mon, 03 Mar 2014 11:03:10 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592604#M478805 alexandros17 2014-03-03T11:03:10Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592605#M478806 <HTML><HEAD></HEAD><BODY><P>COUNT(Distinct <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">RowID</SPAN>)</P></BODY></HTML> Mon, 03 Mar 2014 11:07:43 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592605#M478806 MK_QSL 2014-03-03T11:07:43Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592606#M478807 <HTML><HEAD></HEAD><BODY><P><STRONG>=count(recno())</STRONG></P></BODY></HTML> Mon, 03 Mar 2014 11:08:55 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592606#M478807 2014-03-03T11:08:55Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592607#M478808 <HTML><HEAD></HEAD><BODY><P>That great.&nbsp; Thanks</P></BODY></HTML> Mon, 03 Mar 2014 11:14:52 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592607#M478808 2014-03-03T11:14:52Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592608#M478809 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13938454194267743" jivemacro_uid="_13938454194267743"> <P></P> </PRE><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1393845427207559" jivemacro_uid="_1393845427207559"> <P>=Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Distinct</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">RowID</SPAN>)</P> </PRE></BODY></HTML> Mon, 03 Mar 2014 11:17:17 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592608#M478809 2014-03-03T11:17:17Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592609#M478810 <HTML><HEAD></HEAD><BODY><P>Thank you all for your help.</P></BODY></HTML> Mon, 03 Mar 2014 11:20:58 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592609#M478810 2014-03-03T11:20:58Z Re: Distinct Count on Row https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592610#M478811 <HTML><HEAD></HEAD><BODY><P>hi bhavin,</P><P>if you find your Answer then plz Close this Discussion / Thread</P><P>by Choosing Correct Answer </P></BODY></HTML> Mon, 03 Mar 2014 11:29:26 GMT https://community.qlik.com/t5/QlikView/Distinct-Count-on-Row/m-p/592610#M478811 2014-03-03T11:29:26Z