topic Re: Count and NODISTINCT in QlikView https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727177#M475431 <HTML><HEAD></HEAD><BODY><P>Grazie mille <A href="https://community.qlik.com/qlik-users/82367">Alessandro Saccone</A>!!!!!! non riuscivo proprio a capire dove sbagliassi...grazie!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 22 Jul 2014 15:03:57 GMT 2014-07-22T15:03:57Z Count and NODISTINCT https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727175#M475429 <HTML><HEAD></HEAD><BODY><P>I don't understand which kind of formula I must use and how to write it...I must count the number of suppliers and even if they are repeated, they must be counted! in the file I use </P><P></P><P>count([Ragione Sociale Fornitore])</P><P></P><P>but this formula gives me 15 instead of 18 (since 3 suppliers are repeated). How can I get 18???</P><P></P><P>Please find the file attached</P></BODY></HTML> Tue, 22 Jul 2014 13:46:24 GMT https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727175#M475429 2014-07-22T13:46:24Z Re: Count and NODISTINCT https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727176#M475430 <HTML><HEAD></HEAD><BODY><P>Sono riuscito a scaricare il documento:</P><P></P><P>ecco l'espressione che ti serve ...</P><P></P><P>Sum(Aggr(count( [Ragione Sociale Fornitore]), [Numero Documento]))</P><P></P><P>fammi sapere</P></BODY></HTML> Tue, 22 Jul 2014 13:55:17 GMT https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727176#M475430 alexandros17 2014-07-22T13:55:17Z Re: Count and NODISTINCT https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727177#M475431 <HTML><HEAD></HEAD><BODY><P>Grazie mille <A href="https://community.qlik.com/qlik-users/82367">Alessandro Saccone</A>!!!!!! non riuscivo proprio a capire dove sbagliassi...grazie!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 22 Jul 2014 15:03:57 GMT https://community.qlik.com/t5/QlikView/Count-and-NODISTINCT/m-p/727177#M475431 2014-07-22T15:03:57Z