topic Why Count on Association Field Gives me an Error? in QlikView https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302742#M112005 <HTML><HEAD></HEAD><BODY><P>Hi Martina,</P><P></P><P>Thanks for your answer. I have marked this as Helpful Answer since the solution to use the same field again with a different name and count on this new name, was a good workaround. I used it and it works. </P><P></P><P>Still, I cannot understand why I get "Total count n/a" when I create a statistics box on an association field that links two tables. I can only assume that, since this field appears in more than one table, It does not know which table to use to count the values from? Is this the problem? If "yes", is there a way to tell it to construct the statistics box using the field from a specific table?</P><P></P><P>Thanks in advance</P><P></P><P>Panayotis</P></BODY></HTML> Thu, 15 Dec 2011 10:26:24 GMT 2011-12-15T10:26:24Z Why Count on Association Field Gives me an Error? https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302740#M112003 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a statistics box that does a count on an association field. But, this does not work.</P><P></P><P>Is there any explanation for that?</P><P></P><P>Panayotis</P></BODY></HTML> Thu, 15 Dec 2011 10:05:53 GMT https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302740#M112003 2011-12-15T10:05:53Z Why Count on Association Field Gives me an Error? https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302741#M112004 <HTML><HEAD></HEAD><BODY><P>Hi, Panayotis,</P><P></P><P>in QlikView is every field unique even, if it is an association field, here it stores how often the content of this field is in the associated tables, maybe a sales person sells lots of products to lots of customers:</P><P></P><P>that means to count the sales persons unique, use: Count(Distinct SalesPerson)</P><P></P><P>better you enter the same field again with another name, than you can count them.</P><P></P><P>Greetings from Munich</P><P></P><P>Martina Brenner</P><P>EVACO GmbH</P></BODY></HTML> Thu, 15 Dec 2011 10:17:00 GMT https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302741#M112004 brenner_martina 2011-12-15T10:17:00Z Why Count on Association Field Gives me an Error? https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302742#M112005 <HTML><HEAD></HEAD><BODY><P>Hi Martina,</P><P></P><P>Thanks for your answer. I have marked this as Helpful Answer since the solution to use the same field again with a different name and count on this new name, was a good workaround. I used it and it works. </P><P></P><P>Still, I cannot understand why I get "Total count n/a" when I create a statistics box on an association field that links two tables. I can only assume that, since this field appears in more than one table, It does not know which table to use to count the values from? Is this the problem? If "yes", is there a way to tell it to construct the statistics box using the field from a specific table?</P><P></P><P>Thanks in advance</P><P></P><P>Panayotis</P></BODY></HTML> Thu, 15 Dec 2011 10:26:24 GMT https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302742#M112005 2011-12-15T10:26:24Z Why Count on Association Field Gives me an Error? https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302743#M112006 <HTML><HEAD></HEAD><BODY><P>Hi, Panayotis,</P><P></P><P>this is exactly the point, in the statistics box you have to use even the new created field. In QlikView is every fieldname only once in the structure, the associated fields seem to be there twice or more, but definitively they are not doubled. This is the specific structure of the associative database!</P><P></P><P>Greetings from Munich</P><P></P><P>Martina Brenner</P><P>EVACO GmbH</P></BODY></HTML> Thu, 15 Dec 2011 11:20:14 GMT https://community.qlik.com/t5/QlikView/Why-Count-on-Association-Field-Gives-me-an-Error/m-p/302743#M112006 brenner_martina 2011-12-15T11:20:14Z