topic Re: I'm getting wrong data for some accounts in QlikView https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812665#M286821 <HTML><HEAD></HEAD><BODY><P>Hi Jeremiah,</P><P></P><P><STRONG>count(distinct SHORT_MBO_NAME) wouldn't help because if I do that, all the statuses will be counted as 1 each which is not true. There are 48 accounts in total and each account has 7 MBO's and I have data for 3 months. So total should come up to 48*3*7= 1008.</STRONG></P><P></P><P></P></BODY></HTML> Tue, 11 Nov 2014 21:10:15 GMT 2014-11-11T21:10:15Z I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812663#M286819 <HTML><HEAD></HEAD><BODY><P>The total should be 21.</P></BODY></HTML> Tue, 11 Nov 2014 20:29:55 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812663#M286819 2014-11-11T20:29:55Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812664#M286820 <HTML><HEAD></HEAD><BODY><P>I would use <STRONG>count(distinct SHORT_MBO_NAME)</STRONG> instead.</P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 11 Nov 2014 20:54:04 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812664#M286820 jerem1234 2014-11-11T20:54:04Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812665#M286821 <HTML><HEAD></HEAD><BODY><P>Hi Jeremiah,</P><P></P><P><STRONG>count(distinct SHORT_MBO_NAME) wouldn't help because if I do that, all the statuses will be counted as 1 each which is not true. There are 48 accounts in total and each account has 7 MBO's and I have data for 3 months. So total should come up to 48*3*7= 1008.</STRONG></P><P></P><P></P></BODY></HTML> Tue, 11 Nov 2014 21:10:15 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812665#M286821 2014-11-11T21:10:15Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812666#M286822 <HTML><HEAD></HEAD><BODY><P>create a compound key?</P><P></P><P>Count(distinct (Field1 &amp;'|'&amp; Field2 &amp;'|'&amp; Field3))</P><P></P><P>Preferred method would be to create this multi field key in the load script</P></BODY></HTML> Tue, 11 Nov 2014 21:12:54 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812666#M286822 2014-11-11T21:12:54Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812667#M286823 <HTML><HEAD></HEAD><BODY><P>Thanks David. But it didn't work!!</P></BODY></HTML> Tue, 11 Nov 2014 23:35:24 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812667#M286823 2014-11-11T23:35:24Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812668#M286824 <HTML><HEAD></HEAD><BODY><P>You should be able to simple group the three fields you want to count...and do a count(distinct Field1&amp;field2&amp;field3)</P></BODY></HTML> Wed, 12 Nov 2014 13:56:50 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812668#M286824 2014-11-12T13:56:50Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812669#M286825 <HTML><HEAD></HEAD><BODY><P><BR />Thanks David. It worked.</P></BODY></HTML> Wed, 12 Nov 2014 21:23:16 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812669#M286825 2014-11-12T21:23:16Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812670#M286826 <HTML><HEAD></HEAD><BODY><P>Great! Please mark Question as answered <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Thu, 13 Nov 2014 14:55:53 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812670#M286826 2014-11-13T14:55:53Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812671#M286827 <HTML><HEAD></HEAD><BODY><P>Good rule for the future is to name your forums with the specific question, so the next person with your problem can find the solution.</P><P></P><P>"Count the distinct of multiple fields" would be a good name - may want to change it</P></BODY></HTML> Thu, 13 Nov 2014 15:00:51 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812671#M286827 2014-11-13T15:00:51Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812672#M286828 <HTML><HEAD></HEAD><BODY><P>Done. Thanks David.</P></BODY></HTML> Thu, 13 Nov 2014 18:49:58 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812672#M286828 2014-11-13T18:49:58Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812673#M286829 <HTML><HEAD></HEAD><BODY><P>Definitely, I'll do it from next time David. Anyways thanks for your time and effort. I appreciate it. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Nov 2014 18:50:56 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812673#M286829 2014-11-13T18:50:56Z Re: I'm getting wrong data for some accounts https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812674#M286830 <HTML><HEAD></HEAD><BODY><P>my pleasure, can you please mark my answer as the right answer ?</P></BODY></HTML> Thu, 13 Nov 2014 19:37:09 GMT https://community.qlik.com/t5/QlikView/I-m-getting-wrong-data-for-some-accounts/m-p/812674#M286830 2014-11-13T19:37:09Z