topic Count Distinct in QlikView https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/144231#M23233 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><I></I></P><P></P><P>count</P><P></P><P></P>(distinct {$&lt;Kalender.Kalender.Jahr={<B><I>$(=Only(Kalender.Kalender.Jahr))</I></B>}&gt;} Billing_Header.Billing_Header.SalesDoc_ID <P>)</P><BR /><BR /> <BR /><BR /> <P>I'm trying to get a count of no of unice SelesDoc_ID using set analysis but i become more count as row number</P><P>Thanks</P><P>Shideh</P><P></P><P></P></BODY></HTML> Fri, 15 May 2009 19:26:29 GMT 2009-05-15T19:26:29Z Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/144231#M23233 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><I></I></P><P></P><P>count</P><P></P><P></P>(distinct {$&lt;Kalender.Kalender.Jahr={<B><I>$(=Only(Kalender.Kalender.Jahr))</I></B>}&gt;} Billing_Header.Billing_Header.SalesDoc_ID <P>)</P><BR /><BR /> <BR /><BR /> <P>I'm trying to get a count of no of unice SelesDoc_ID using set analysis but i become more count as row number</P><P>Thanks</P><P>Shideh</P><P></P><P></P></BODY></HTML> Fri, 15 May 2009 19:26:29 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/144231#M23233 2009-05-15T19:26:29Z Count Distinct https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/144232#M23234 <HTML><HEAD></HEAD><BODY><P>I don't understand your formula ???</P><P>the test <B>value = only(value)</B> is always true in a table with value as dimension .</P><P>why not using</P><P style="font-weight: bold">count(distinct if(invoice_year=$(yy_input),invoice_id,null())</P><P>the <B>yy_input</B> is a variable you can input, or define i.e. as year(reloaddate()).</P><P></P></BODY></HTML> Sat, 16 May 2009 17:11:36 GMT https://community.qlik.com/t5/QlikView/Count-Distinct/m-p/144232#M23234 yblake 2009-05-16T17:11:36Z