topic Re: Count of emp miscount in QlikView https://community.qlik.com/t5/QlikView/miscount/m-p/1004042#M341125 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>if you see the expression in the chart its already applied distinct.</P></BODY></HTML> Mon, 30 Nov 2015 09:22:38 GMT 2015-11-30T09:22:38Z miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004036#M341119 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>I have a chart which has the count of employees </P></BODY></HTML> Sun, 29 Nov 2015 15:58:56 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004036#M341119 2015-11-29T15:58:56Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004037#M341120 <HTML><HEAD></HEAD><BODY><P>which one is your date field??</P></BODY></HTML> Mon, 30 Nov 2015 05:27:06 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004037#M341120 Anonymous 2015-11-30T05:27:06Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004038#M341121 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you explain little more and give expected output?</P><P></P><P></P><P>-Nagarjuna</P></BODY></HTML> Mon, 30 Nov 2015 05:47:13 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004038#M341121 nagarjuna_kotha 2015-11-30T05:47:13Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004039#M341122 <HTML><HEAD></HEAD><BODY><P>Thanks Balraj</P><P>RS_DT is the date field</P></BODY></HTML> Mon, 30 Nov 2015 09:05:26 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004039#M341122 2015-11-30T09:05:26Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004040#M341123 <HTML><HEAD></HEAD><BODY><P>Hello Nagarjuna thanks for the reply</P><P>requirement is i need to get the count of employees as 74 but now i am getting as 99.</P><P>I need to correct the number and requesting your help on this</P></BODY></HTML> Mon, 30 Nov 2015 09:06:39 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004040#M341123 2015-11-30T09:06:39Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004041#M341124 <HTML><HEAD></HEAD><BODY><P>Try this-</P><P></P><P>Take discount count of employees.. might be your data has duplicate records..</P><P></P><P>Sreeni</P></BODY></HTML> Mon, 30 Nov 2015 09:11:03 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004041#M341124 SreeniJD 2015-11-30T09:11:03Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004042#M341125 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>if you see the expression in the chart its already applied distinct.</P></BODY></HTML> Mon, 30 Nov 2015 09:22:38 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004042#M341125 2015-11-30T09:22:38Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004043#M341126 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>On what we should calculate count of employees.</P><P>Could you please clarify ?</P></BODY></HTML> Mon, 30 Nov 2015 09:29:18 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004043#M341126 Anonymous 2015-11-30T09:29:18Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004044#M341127 <HTML><HEAD></HEAD><BODY><P>Hello rgv</P><P>in the chart expression,we have the conditions to apply the count</P><P>please open the attachment</P></BODY></HTML> Mon, 30 Nov 2015 09:34:48 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004044#M341127 2015-11-30T09:34:48Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004045#M341128 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>in which year you want count 74 2014 or 2015 .for 2014 its giving 73 Count .</P><P></P><P></P><P>As per ur data in your dashboard its giving correct.</P><P>are you sure ,after reloading its giving correct count . If yes .Did you save after reloading your application.again if yes ,Create new app and copy same script reload it and save.</P><P></P><P>Some times becoz of Bugs this situation come.</P><P></P><P>-Nagarjuna</P></BODY></HTML> Mon, 30 Nov 2015 09:45:47 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004045#M341128 nagarjuna_kotha 2015-11-30T09:45:47Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004046#M341129 <HTML><HEAD></HEAD><BODY><P>Hello Nagarjuna</P><P>thanks for the reply</P><P>i need the count to be as 73 for 2015 year</P></BODY></HTML> Mon, 30 Nov 2015 09:49:17 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004046#M341129 2015-11-30T09:49:17Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004047#M341130 <HTML><HEAD></HEAD><BODY><P>any help?</P></BODY></HTML> Mon, 30 Nov 2015 12:02:34 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004047#M341130 2015-11-30T12:02:34Z Re: Count of emp miscount https://community.qlik.com/t5/QlikView/miscount/m-p/1004048#M341131 <HTML><HEAD></HEAD><BODY><P>It's always better to create something in QlikView based on a business logic than something translated from SQL. Please omit the "I have to get 74" and try to explain what logic you want to implement in the straight table</P></BODY></HTML> Mon, 30 Nov 2015 13:50:33 GMT https://community.qlik.com/t5/QlikView/miscount/m-p/1004048#M341131 Peter_Cammaert 2015-11-30T13:50:33Z