topic Re: average data in QlikView https://community.qlik.com/t5/QlikView/average-data/m-p/1122533#M633608 <HTML><HEAD></HEAD><BODY><P>Either use Avg() function or aggregate your measure and divide by e.g. number of distinct dates in your period:</P><P><A href="https://community.qlik.com/qlik-blogpost/3208">Average – Which average?</A></P><P></P><P>If you want to limit the data to the present week, either use a conditional function or set analysis:</P><P></P><P>=Avg( If( DateField &gt;= Weekstart(Today()) and DateField &lt;= Weekend(Today()), ValueField))</P><P></P><P>or</P><P></P><P>Avg({&lt;DateField&nbsp; = {"&gt;=$(=Date(Weekstart(Today())))&lt;=$(=Date(Weekend(Today())))"} &gt;} ValueField)</P><P></P><P>See also </P><P><A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A></P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Sat, 09 Jul 2016 09:15:13 GMT swuehl 2016-07-09T09:15:13Z average data https://community.qlik.com/t5/QlikView/average-data/m-p/1122532#M633607 <HTML><HEAD></HEAD><BODY><P>I want to calculate data which would be average for present week. how to achieve this ?</P></BODY></HTML> Fri, 08 Jul 2016 22:58:44 GMT https://community.qlik.com/t5/QlikView/average-data/m-p/1122532#M633607 qvqfqlik 2016-07-08T22:58:44Z Re: average data https://community.qlik.com/t5/QlikView/average-data/m-p/1122533#M633608 <HTML><HEAD></HEAD><BODY><P>Either use Avg() function or aggregate your measure and divide by e.g. number of distinct dates in your period:</P><P><A href="https://community.qlik.com/qlik-blogpost/3208">Average – Which average?</A></P><P></P><P>If you want to limit the data to the present week, either use a conditional function or set analysis:</P><P></P><P>=Avg( If( DateField &gt;= Weekstart(Today()) and DateField &lt;= Weekend(Today()), ValueField))</P><P></P><P>or</P><P></P><P>Avg({&lt;DateField&nbsp; = {"&gt;=$(=Date(Weekstart(Today())))&lt;=$(=Date(Weekend(Today())))"} &gt;} ValueField)</P><P></P><P>See also </P><P><A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A></P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Sat, 09 Jul 2016 09:15:13 GMT https://community.qlik.com/t5/QlikView/average-data/m-p/1122533#M633608 swuehl 2016-07-09T09:15:13Z