topic Re: AVG DAYS in QlikView https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874696#M1003263 <HTML><HEAD></HEAD><BODY><P>agreed sir </P><P></P><P>But is any possible way of doing it as i want to show both days as well as AVG over period of time </P><P></P><P>Thanking You</P><P>Vinayagam</P></BODY></HTML> Thu, 11 Jun 2015 14:55:20 GMT Anonymous 2015-06-11T14:55:20Z AVG DAYS https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874692#M1003259 <HTML><HEAD></HEAD><BODY><P>Hi all i am trying to derive Avg Days using following expressions it works exactly the way i want but as soon as i add dimension&nbsp; <SPAN style="font-size: 13.3333330154419px;">PRODDATE , the dimension <SPAN style="font-size: 13.3333330154419px;">PRODDATE is not visble pls help</SPAN></SPAN></P><P></P><P>AVG(AGGR(COUNT({&lt;<SPAN style="font-size: 13.3333330154419px;">PRODDATE</SPAN>= {"&gt;=$(vStartDate)&lt;=$(vLastDate)"},EDITION_CAT={'M'},PUBLICATION_TYPE={'DS'},EDTION_TYPE={'Newspaper'}&gt;}DISTINCT </P><P>(PRODDATE)),STATE_LINK,LINKCITY1,PUBLICATION_TYPE,CITYSAT,PRODUCT_CONTANT_CATEGORY))</P><P></P><P>Thanks In advance </P><P>Vinayagam</P></BODY></HTML> Thu, 11 Jun 2015 12:39:12 GMT https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874692#M1003259 Anonymous 2015-06-11T12:39:12Z Re: AVG DAYS https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874693#M1003260 <HTML><HEAD></HEAD><BODY><P>Sorry, I don't fully understand.</P><P></P><P>the dimension PRODDATE is not visible ... Where it is not visible? In which context are you using this expression?</P><P></P><P>You might consider adding the set expression also to the outer aggregation (avg() function).</P></BODY></HTML> Thu, 11 Jun 2015 12:47:04 GMT https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874693#M1003260 swuehl 2015-06-11T12:47:04Z Re: AVG DAYS https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874694#M1003261 <HTML><HEAD></HEAD><BODY><P>hi i am using this expression in Pivot table</P><P></P><P></P><P></P><P><IMG alt="DATE.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89098_DATE.png" style="height: auto;" /></P></BODY></HTML> Thu, 11 Jun 2015 12:51:45 GMT https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874694#M1003261 Anonymous 2015-06-11T12:51:45Z Re: AVG DAYS https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874695#M1003262 <HTML><HEAD></HEAD><BODY><P>Your expression is calculating over a date range, so how can there be a single PRODDATE?</P><P></P><P>Andy</P></BODY></HTML> Thu, 11 Jun 2015 14:21:29 GMT https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874695#M1003262 awhitfield 2015-06-11T14:21:29Z Re: AVG DAYS https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874696#M1003263 <HTML><HEAD></HEAD><BODY><P>agreed sir </P><P></P><P>But is any possible way of doing it as i want to show both days as well as AVG over period of time </P><P></P><P>Thanking You</P><P>Vinayagam</P></BODY></HTML> Thu, 11 Jun 2015 14:55:20 GMT https://community.qlik.com/t5/QlikView/AVG-DAYS/m-p/874696#M1003263 Anonymous 2015-06-11T14:55:20Z