topic Re: Count in QlikView https://community.qlik.com/t5/QlikView/Count/m-p/726777#M475436 <HTML><HEAD></HEAD><BODY><P>Provide sample data file....</P></BODY></HTML> Tue, 22 Jul 2014 12:06:14 GMT MK_QSL 2014-07-22T12:06:14Z Count https://community.qlik.com/t5/QlikView/Count/m-p/726773#M475432 <HTML><HEAD></HEAD><BODY><P>I have done this kind of statistics several time, but this time I don't understand what I'm doing wrong. I would like to count the number of suppliers so I'm using the formula =count([Ragione Sociale Fornitore]) that I've always used. The point is that in case the supplier is repeated, it is counted only once, while I want to be counted twice.</P><P>What I'm doing wrong???</P></BODY></HTML> Tue, 22 Jul 2014 11:53:59 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726773#M475432 2014-07-22T11:53:59Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726774#M475433 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>can you attach the sample apps.</P></BODY></HTML> Tue, 22 Jul 2014 11:59:36 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726774#M475433 mdmukramali 2014-07-22T11:59:36Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726775#M475434 <HTML><HEAD></HEAD><BODY><P>You will have to remove Column2 and Column3 from your dimensions.</P><P>Then you will get the correct count.</P><P>"Numero .." and "Data ..." dimension fields are showing the details.</P><P>To make count aggregate to first field, remove the other two fields from dimension list.</P></BODY></HTML> Tue, 22 Jul 2014 12:04:32 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726775#M475434 anandathome 2014-07-22T12:04:32Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726776#M475435 <HTML><HEAD></HEAD><BODY><P>Hi Irene</P><P></P><P>If you are interest in the number of suppliers, I think you have got the correct result: 15.</P><P></P><P>18 is not the number of suppliers, as you can see some are duplicated.</P><P></P><P>18 may be the number of [Numero doc...], so try a count([Numero doc...])</P></BODY></HTML> Tue, 22 Jul 2014 12:05:35 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726776#M475435 gandalfgray 2014-07-22T12:05:35Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726777#M475436 <HTML><HEAD></HEAD><BODY><P>Provide sample data file....</P></BODY></HTML> Tue, 22 Jul 2014 12:06:14 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726777#M475436 MK_QSL 2014-07-22T12:06:14Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726778#M475437 <HTML><HEAD></HEAD><BODY><P>I've already tried the Count(num_doc) still not working...</P></BODY></HTML> Tue, 22 Jul 2014 12:08:09 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726778#M475437 2014-07-22T12:08:09Z Re: Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726779#M475438 <HTML><HEAD></HEAD><BODY><P>The chart is already opened and filtered</P></BODY></HTML> Tue, 22 Jul 2014 12:09:05 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726779#M475438 2014-07-22T12:09:05Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726780#M475439 <HTML><HEAD></HEAD><BODY><P>have you tried like this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">aggr(nodistinct count([Ragione Sociale Fornitore]),yourdimension field)</SPAN></P></BODY></HTML> Tue, 22 Jul 2014 12:20:10 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726780#M475439 er_mohit 2014-07-22T12:20:10Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726781#M475440 <HTML><HEAD></HEAD><BODY><P>I've provided data sample in the answer to @Mohammed Mukram Ali</P></BODY></HTML> Tue, 22 Jul 2014 12:21:02 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726781#M475440 2014-07-22T12:21:02Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726782#M475441 <HTML><HEAD></HEAD><BODY><P>Mi spiace ma non riesco ad aprire il tuo documento ...</P></BODY></HTML> Tue, 22 Jul 2014 12:21:14 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726782#M475441 alexandros17 2014-07-22T12:21:14Z Re: Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726783#M475442 <HTML><HEAD></HEAD><BODY><P>ho provato a riattacarlo...prova un po' di nuovo...</P></BODY></HTML> Tue, 22 Jul 2014 12:26:20 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726783#M475442 2014-07-22T12:26:20Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726784#M475443 <HTML><HEAD></HEAD><BODY><P>You are using a pivottable. The pivot on column "Codie Do..." is represented once. Try using a straight table.</P></BODY></HTML> Tue, 22 Jul 2014 12:34:54 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726784#M475443 richard 2014-07-22T12:34:54Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726785#M475444 <HTML><HEAD></HEAD><BODY><P>Purtroppo non riesco ancora, fai così comunque:</P><P></P><P>carica in una tabella piatta i dati e verifica quante ragioni sociali hai, se sono 15 allora il risultato è corretto, altrimenti count(num_doc) dovrebbe funzionare, che risultato i da?</P></BODY></HTML> Tue, 22 Jul 2014 12:35:10 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726785#M475444 alexandros17 2014-07-22T12:35:10Z Re: Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726786#M475445 <HTML><HEAD></HEAD><BODY><P>addirittura 59...</P></BODY></HTML> Tue, 22 Jul 2014 12:38:47 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726786#M475445 2014-07-22T12:38:47Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726787#M475446 <HTML><HEAD></HEAD><BODY><P>I must use a pivot chart though...cannot change it...</P></BODY></HTML> Tue, 22 Jul 2014 12:39:56 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726787#M475446 2014-07-22T12:39:56Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726788#M475447 <HTML><HEAD></HEAD><BODY><P>Prova così:</P><P></P><P>Count(Aggr(num_doc, codice_doc))</P><P></P><P>Fammi sapere ...</P></BODY></HTML> Tue, 22 Jul 2014 12:49:58 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726788#M475447 alexandros17 2014-07-22T12:49:58Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726789#M475448 <HTML><HEAD></HEAD><BODY><P>niente...no dà alcun risultato...</P></BODY></HTML> Tue, 22 Jul 2014 12:54:48 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726789#M475448 2014-07-22T12:54:48Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726790#M475449 <HTML><HEAD></HEAD><BODY><P>Devi aggregare (prova altre combinazioni) il conteggio del numero di documenti per la chiave della tabella in cui si trovano ...</P></BODY></HTML> Tue, 22 Jul 2014 12:58:46 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726790#M475449 alexandros17 2014-07-22T12:58:46Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726791#M475450 <HTML><HEAD></HEAD><BODY><P>My solution to this type of problem is to add a field in the script:</P><P></P><P>Suppliers:</P><P>LOAD</P><P>1 as CountSupplier</P><P>...</P><P></P><P>I can then use this in the expression Sum(CountSupplier) and the pivot summation works for all levels.</P><P></P><P>Regards.</P></BODY></HTML> Tue, 22 Jul 2014 13:16:42 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726791#M475450 martynlloyd 2014-07-22T13:16:42Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/726792#M475451 <HTML><HEAD></HEAD><BODY><P>I might think that this expression could it be the solutions </P><P></P><P>=AGGR(NODISTINCT SUM({[Ragione Sociale Fornitore]}),&lt;[Numero Documento],[Data Documento]&gt;)</P><P></P><P>but there is an errore as a fact that I'm not getting any result...does anyone know where and which is the mistake??</P></BODY></HTML> Tue, 22 Jul 2014 13:23:10 GMT https://community.qlik.com/t5/QlikView/Count/m-p/726792#M475451 2014-07-22T13:23:10Z