topic Re: why is the calculation wrong? in QlikView https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806494#M1035857 <HTML><HEAD></HEAD><BODY><P>I noticed that if Id is null also account name is null so maybe you should find another way to count them.</P><P>Find an attachment where in yellow column you can see that number of Id null is the same of the account name null.</P></BODY></HTML> Sun, 18 Jan 2015 17:51:15 GMT Anonymous 2015-01-18T17:51:15Z why is the calculation wrong? https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806491#M1035854 <HTML><HEAD></HEAD><BODY><P>Hello, everyone</P><P></P><P>I want to calculate the distinct account id for each salesman.If account id doesn't exist, I will calculate the distinct account name instead.But we can see from the result, the if expression is not a right answer.Why?</P></BODY></HTML> Sun, 18 Jan 2015 04:39:44 GMT https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806491#M1035854 2015-01-18T04:39:44Z Re: why is the calculation wrong? https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806492#M1035855 <HTML><HEAD></HEAD><BODY><P>the third expression wouln't be?</P><P>if (IsNull([count id]),[count name],[count id])</P></BODY></HTML> Sun, 18 Jan 2015 05:21:14 GMT https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806492#M1035855 2015-01-18T05:21:14Z Re: why is the calculation wrong? https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806493#M1035856 <HTML><HEAD></HEAD><BODY><P>I have tried the solution,but it doesn't work.</P></BODY></HTML> Sun, 18 Jan 2015 06:15:48 GMT https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806493#M1035856 2015-01-18T06:15:48Z Re: why is the calculation wrong? https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806494#M1035857 <HTML><HEAD></HEAD><BODY><P>I noticed that if Id is null also account name is null so maybe you should find another way to count them.</P><P>Find an attachment where in yellow column you can see that number of Id null is the same of the account name null.</P></BODY></HTML> Sun, 18 Jan 2015 17:51:15 GMT https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806494#M1035857 Anonymous 2015-01-18T17:51:15Z Re: why is the calculation wrong? https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806495#M1035858 <HTML><HEAD></HEAD><BODY><P>It happens to be that the id is all not null.From the expression result, the right answer should be 91,the same as count id, but the actual answer is the same as count name.Does the "if" function lose effect?</P></BODY></HTML> Mon, 19 Jan 2015 03:50:12 GMT https://community.qlik.com/t5/QlikView/why-is-the-calculation-wrong/m-p/806495#M1035858 2015-01-19T03:50:12Z