topic Re: How to distinct count ID in QlikView https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891934#M310608 <HTML><HEAD></HEAD><BODY><P>Without seeing a sample, it would be hard to say what might be wrong.</P></BODY></HTML> Thu, 16 Jul 2015 18:16:31 GMT sunny_talwar 2015-07-16T18:16:31Z How to distinct count ID https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891933#M310607 <HTML><HEAD></HEAD><BODY><P>I have a count if statement in my straight table that I am using to distinct count IDs. it is counting the no of records instead even when I use distinct. any idea?</P></BODY></HTML> Thu, 16 Jul 2015 18:15:27 GMT https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891933#M310607 Anonymous 2015-07-16T18:15:27Z Re: How to distinct count ID https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891934#M310608 <HTML><HEAD></HEAD><BODY><P>Without seeing a sample, it would be hard to say what might be wrong.</P></BODY></HTML> Thu, 16 Jul 2015 18:16:31 GMT https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891934#M310608 sunny_talwar 2015-07-16T18:16:31Z Re: How to distinct count ID https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891935#M310609 <HTML><HEAD></HEAD><BODY><P>Count(Distinct ID) should give your expected result. If not, please share some sample/dummy data or sample application. </P><P>Or provide the Data Model, Dimension or Expression you have used..</P></BODY></HTML> Thu, 16 Jul 2015 18:17:02 GMT https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891935#M310609 MK_QSL 2015-07-16T18:17:02Z Re: How to distinct count ID https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891936#M310610 <HTML><HEAD></HEAD><BODY><P>The count was not matching because I had a calculated dimension but in the expression, that dimension was not being used. hence when I copied the expression to the caption of the straight table, it was giving me a diff count than the number of record in the straight table.</P></BODY></HTML> Thu, 16 Jul 2015 19:16:45 GMT https://community.qlik.com/t5/QlikView/How-to-distinct-count-ID/m-p/891936#M310610 Anonymous 2015-07-16T19:16:45Z