topic Re: avg days (DAY WISE) in QlikView https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876329#M1003057 <HTML><HEAD></HEAD><BODY><P>Thanks Sir </P><P></P><P>But if u see the subtotal at state level it shows its different </P></BODY></HTML> Thu, 11 Jun 2015 15:33:29 GMT Anonymous 2015-06-11T15:33:29Z avg days (DAY WISE) https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876327#M1003054 <HTML><HEAD></HEAD><BODY><P>Hi all pls find the attached App,My requirement is to get the mention result days wise.</P><P></P><P>Thanking You</P><P>Vinayagam</P></BODY></HTML> Thu, 11 Jun 2015 15:15:11 GMT https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876327#M1003054 Anonymous 2015-06-11T15:15:11Z Re: avg days (DAY WISE) https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876328#M1003055 <HTML><HEAD></HEAD><BODY><P>=SUM(TOTAL &lt;Centre,State&gt; PO)/COUNT(TOTAL &lt;Centre,State&gt; DISTINCT Date)</P></BODY></HTML> Thu, 11 Jun 2015 15:26:46 GMT https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876328#M1003055 MK_QSL 2015-06-11T15:26:46Z Re: avg days (DAY WISE) https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876329#M1003057 <HTML><HEAD></HEAD><BODY><P>Thanks Sir </P><P></P><P>But if u see the subtotal at state level it shows its different </P></BODY></HTML> Thu, 11 Jun 2015 15:33:29 GMT https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876329#M1003057 Anonymous 2015-06-11T15:33:29Z Re: avg days (DAY WISE) https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876330#M1003058 <HTML><HEAD></HEAD><BODY><P>COULD BE THIS?</P><P></P><P>=avg ( AGGR (SUM(TOTAL &lt;Centre,State&gt; PO)/COUNT(TOTAL &lt;Centre,State&gt; DISTINCT Date) , Date, Centre, State))</P></BODY></HTML> Thu, 11 Jun 2015 19:10:47 GMT https://community.qlik.com/t5/QlikView/avg-days-DAY-WISE/m-p/876330#M1003058 arthur_dom 2015-06-11T19:10:47Z