topic Re : Problem While using the same codition for the function Avg and Median in QlikView https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204051#M61128 <HTML><HEAD></HEAD><BODY><P>I am using QV 9 SR3....</P></BODY></HTML> Wed, 07 Apr 2010 16:09:48 GMT deepakk 2010-04-07T16:09:48Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204044#M61121 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P>In my report, i need to calculate Avg(), Min(), Max() and Median(). Without Median function, the table show the data as per the condition.</P><P>But while adding the Avg and Median function in the same chart neglect the condition present inside it and produce this garbage and null values. Garbage value for Avg () and Null value for Min(), Max(), Median().</P><P>When adding not isNull() function inside the Avg() or Median() produces correct output by eliminating.</P><P>May i know why this issue present and help me with the information you know about this.</P><P>Regards,</P><P>R.Srinivasan.</P></BODY></HTML> Tue, 06 Apr 2010 14:02:42 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204044#M61121 2010-04-06T14:02:42Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204045#M61122 <HTML><HEAD></HEAD><BODY><P>Put a sample Application so we can check and help you out on the same.</P></BODY></HTML> Tue, 06 Apr 2010 14:57:18 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204045#M61122 deepakk 2010-04-06T14:57:18Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204046#M61123 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P>Here i have attached the sample report created just to check for the Avg and median functions.</P><P>We are using QV v8.5.</P></BODY></HTML> Wed, 07 Apr 2010 06:41:50 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204046#M61123 2010-04-07T06:41:50Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204047#M61124 <HTML><HEAD></HEAD><BODY><P>hi Srinivasan,</P><P>Sorry i am not clear but can you tell which table is causing a problem.</P></BODY></HTML> Wed, 07 Apr 2010 08:22:59 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204047#M61124 deepakk 2010-04-07T08:22:59Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204048#M61125 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P>When you see the Chart named "<STRONG>Median and Average Check</STRONG> ", you can see the null values present for the median function and garbage values for avg function.</P><P>But the same function created in different chart i.e., one chart "Average Check"contain only the avg function, it doesn't contain the garbage values. Same for the median, look at the chart "<STRONG>Median Check</STRONG>".</P></BODY></HTML> Wed, 07 Apr 2010 10:58:31 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204048#M61125 2010-04-07T10:58:31Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204049#M61126 <HTML><HEAD></HEAD><BODY><P>HI , Please check my attachment i dont see any null value..!!1</P></BODY></HTML> Wed, 07 Apr 2010 12:48:58 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204049#M61126 deepakk 2010-04-07T12:48:58Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204050#M61127 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P>But i get null values. Here is the screen shot of the report.</P><P>Is this version problem?</P><P>What version do you use?</P></BODY></HTML> Wed, 07 Apr 2010 15:55:58 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204050#M61127 2010-04-07T15:55:58Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204051#M61128 <HTML><HEAD></HEAD><BODY><P>I am using QV 9 SR3....</P></BODY></HTML> Wed, 07 Apr 2010 16:09:48 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204051#M61128 deepakk 2010-04-07T16:09:48Z Re : Problem While using the same codition for the function Avg and Median https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204052#M61129 <HTML><HEAD></HEAD><BODY><P>I'm using 8.50.6231.5, and not seeing the bad values either. I see what Deepak sees. I have no idea what might be causing the weird values.</P></BODY></HTML> Thu, 08 Apr 2010 00:24:02 GMT https://community.qlik.com/t5/QlikView/Re-Problem-While-using-the-same-codition-for-the-function-Avg/m-p/204052#M61129 johnw 2010-04-08T00:24:02Z