topic Re: The abnormal data in QlikView https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555094#M1120927 <HTML><HEAD></HEAD><BODY><P>Related files.</P></BODY></HTML> Thu, 23 Jan 2014 07:25:41 GMT 2014-01-23T07:25:41Z The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555091#M1120924 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When I'm working with my qvw file, it occurs some abnomal data.</P><P><IMG __jive_id="51952" alt="abnormal data.PNG.png" class="jive-image jiveImage" src="/legacyfs/online/51952_abnormal data.PNG.png" /></P><P>And I think my relevant code is all right, so I don't know where exists some issues.</P><P>Please help me! Thanks!</P><P></P><P>Best regards,</P><P>CoCo</P></BODY></HTML> Thu, 23 Jan 2014 06:41:49 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555091#M1120924 2014-01-23T06:41:49Z Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555092#M1120925 <HTML><HEAD></HEAD><BODY><P>Qvd doesn't show data.&nbsp; Could you share sample(reduced and scrambled) app?</P></BODY></HTML> Thu, 23 Jan 2014 07:11:04 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555092#M1120925 tresB 2014-01-23T07:11:04Z Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555093#M1120926 <HTML><HEAD></HEAD><BODY><P>Related files.</P></BODY></HTML> Thu, 23 Jan 2014 07:18:56 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555093#M1120926 2014-01-23T07:18:56Z Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555094#M1120927 <HTML><HEAD></HEAD><BODY><P>Related files.</P></BODY></HTML> Thu, 23 Jan 2014 07:25:41 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555094#M1120927 2014-01-23T07:25:41Z Re: Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555095#M1120928 <HTML><HEAD></HEAD><BODY><P>Related files.</P></BODY></HTML> Thu, 23 Jan 2014 07:33:06 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555095#M1120928 2014-01-23T07:33:06Z Re: Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555096#M1120929 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P></P><P>I've attached the relevant files. Please hava a look. Thanks.</P><P></P><P>Best regards,</P><P>CoCo</P></BODY></HTML> Thu, 23 Jan 2014 07:34:47 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555096#M1120929 2014-01-23T07:34:47Z Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555097#M1120930 <HTML><HEAD></HEAD><BODY><P>Goto the definition of variable vOtherTotal, put '=' before the expression.</P></BODY></HTML> Thu, 23 Jan 2014 08:01:55 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555097#M1120930 tresB 2014-01-23T08:01:55Z Re: Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555098#M1120931 <HTML><HEAD></HEAD><BODY><P>Oh, Great! Thanks too much.</P><P></P><P>But the variable "vMBTotal" is also like "vOtherTotal", and the corresponding result is right. So why?</P><P><IMG alt="normal data.PNG.png" class="jive-image" src="/legacyfs/online/51960_normal data.PNG.png" style="width: 620px; height: 118px;" /></P></BODY></HTML> Thu, 23 Jan 2014 08:20:16 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555098#M1120931 2014-01-23T08:20:16Z Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555099#M1120932 <HTML><HEAD></HEAD><BODY><P>Because, in the vOtherTotal, you have two expression like Count(A)-Count(B), Ultimately if it gets expanded in the chart expression then becomes something like Exp1/Count(A)-Count(B), which is wrong, you actually need, Exp1/(count(a)-count(b)). but for vMBTotal, it is single count(), so there would not an issue if gets expanded in the chart, it would be Exp1/Count(a)... which is no different. If you put an equal sign in the variable definition, then the variable expansion would not cause the issue, because it is evaluated first. Hope it helps you understand.</P><P></P><P>Edit: for better understanding refer : <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables">http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables</A></P></BODY></HTML> Thu, 23 Jan 2014 08:40:43 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555099#M1120932 tresB 2014-01-23T08:40:43Z Re: Re: The abnormal data https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555100#M1120933 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P></P><P>You explain very good. I understand.&nbsp; Thanks too much.</P><P></P><P>Best regards,</P><P>CoCo.</P></BODY></HTML> Thu, 23 Jan 2014 08:44:24 GMT https://community.qlik.com/t5/QlikView/The-abnormal-data/m-p/555100#M1120933 2014-01-23T08:44:24Z