topic Re: Double count records in QlikView https://community.qlik.com/t5/QlikView/Double-count-records/m-p/460927#M172068 <HTML><HEAD></HEAD><BODY><P>If you have to detail the count by grade, and if a student has both grades A and B but should count as 1, he would have to count as 1 in A and 0 in B for example, and this doesn't make sense. </P><P></P><P>I think that your requirement is inconsistent with your chart configuration. Or I didn't understand you... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 23 Nov 2012 17:52:10 GMT fosuzuki 2012-11-23T17:52:10Z Double count records https://community.qlik.com/t5/QlikView/Double-count-records/m-p/460926#M172067 <HTML><HEAD></HEAD><BODY><P>The attached QVW file consists of two bar charts. The upper bar chart is correct. It shows the number of letter grades.</P><P>The bottom bar chart tries to count the number of students for each grade. It's correct if I only select one letter grade.</P><P>However, if I select more than one letter grades such as A and B, the same student having both grade A and B is counted twice.</P><P>Any advice to resolve this problem? </P><P>Thanks.</P></BODY></HTML> Fri, 23 Nov 2012 03:50:20 GMT https://community.qlik.com/t5/QlikView/Double-count-records/m-p/460926#M172067 2012-11-23T03:50:20Z Re: Double count records https://community.qlik.com/t5/QlikView/Double-count-records/m-p/460927#M172068 <HTML><HEAD></HEAD><BODY><P>If you have to detail the count by grade, and if a student has both grades A and B but should count as 1, he would have to count as 1 in A and 0 in B for example, and this doesn't make sense. </P><P></P><P>I think that your requirement is inconsistent with your chart configuration. Or I didn't understand you... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 23 Nov 2012 17:52:10 GMT https://community.qlik.com/t5/QlikView/Double-count-records/m-p/460927#M172068 fosuzuki 2012-11-23T17:52:10Z