topic Re: Issue with Average in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709552#M1068539 <HTML><HEAD></HEAD><BODY><P>Provide me some proper 10 lines sample data. Would like to help you on this matter...</P></BODY></HTML> Thu, 04 Sep 2014 13:09:37 GMT MK_QSL 2014-09-04T13:09:37Z Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709546#M1068533 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I had come up with a scenario, where I should calculate the number of days between two dates for a particular instance. Then after calculating the days between them, i need the avg of those days.</P><P></P><P>So, in the expression I gave avg(Days), when I cross check the data manually it is varying.</P><P></P><P>So should i write something else in the expression??</P><P></P><P>Kindly help me in this scenario.</P><P></P><P>Thanks,</P><P>Sindhu</P></BODY></HTML> Thu, 04 Sep 2014 11:51:17 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709546#M1068533 2014-09-04T11:51:17Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709547#M1068534 <HTML><HEAD></HEAD><BODY><P>Number of Days between two Dates...</P><P></P><P>Interval(Date2-Date1,'dd')</P><P></P><P>But don't get the logic behind Avg of this !</P></BODY></HTML> Thu, 04 Sep 2014 11:52:54 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709547#M1068534 MK_QSL 2014-09-04T11:52:54Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709548#M1068535 <HTML><HEAD></HEAD><BODY><P>avg(Date2 - Date1)</P></BODY></HTML> Thu, 04 Sep 2014 11:56:31 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709548#M1068535 maxgro 2014-09-04T11:56:31Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709549#M1068536 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I had calculated the number of days with networkdays formula, where i'm able to achieve the days.</P><P>But the issue with calculating the average of all those days.</P><P>Eg..</P><P>3</P><P>4</P><P>5</P><P>6</P><P>these are the days with respect to some instance, now the average of (3,4,5,6) i need, when i use avg(days) its giving wrong results.</P><P></P><P>Hope this gives an idea.</P></BODY></HTML> Thu, 04 Sep 2014 11:56:51 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709549#M1068536 2014-09-04T11:56:51Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709550#M1068537 <HTML><HEAD></HEAD><BODY><P>You should use </P><P>Aggr(Avg(Days),YourDimension)</P></BODY></HTML> Thu, 04 Sep 2014 12:00:25 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709550#M1068537 MK_QSL 2014-09-04T12:00:25Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709551#M1068538 <HTML><HEAD></HEAD><BODY><P>I have tried, but it didn't work.</P></BODY></HTML> Thu, 04 Sep 2014 13:02:09 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709551#M1068538 2014-09-04T13:02:09Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709552#M1068539 <HTML><HEAD></HEAD><BODY><P>Provide me some proper 10 lines sample data. Would like to help you on this matter...</P></BODY></HTML> Thu, 04 Sep 2014 13:09:37 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709552#M1068539 MK_QSL 2014-09-04T13:09:37Z Re: Issue with Average https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709553#M1068540 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Thanks for your help.</P><P></P><P>I missed one logic in the script, now I have fixed and able to get the results.</P></BODY></HTML> Thu, 11 Sep 2014 05:50:11 GMT https://community.qlik.com/t5/QlikView/Issue-with-Average/m-p/709553#M1068540 2014-09-11T05:50:11Z