topic Re: Average in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604054#M1101623 <HTML><HEAD></HEAD><BODY><P>Write like</P><P></P><P></P><P>Ex:-&nbsp; Sales / GetSelectedCount(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">day</SPAN>)</P><P></P><P>For Example:-</P><P></P><P>=&nbsp; ( Sum(YourSalesFieldHere) / GetSelectedCount(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">YourDayFieldHere</SPAN>) )</P></BODY></HTML> Tue, 22 Apr 2014 13:52:30 GMT its_anandrjs 2014-04-22T13:52:30Z Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604051#M1101620 <HTML><HEAD></HEAD><BODY><P>QlikView Dashboard when select No of days(EX-1,2,3,4) Then Show Average Of (4) Selected Days in expression Field</P></BODY></HTML> Tue, 22 Apr 2014 13:13:16 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604051#M1101620 vijayit43 2014-04-22T13:13:16Z Re: Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604052#M1101621 <HTML><HEAD></HEAD><BODY><P>can you elaborate little bit more?</P><P></P><P>You can have average as below</P><P></P><P>Avg(Sales)</P></BODY></HTML> Tue, 22 Apr 2014 13:16:13 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604052#M1101621 MK_QSL 2014-04-22T13:16:13Z Re: Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604053#M1101622 <HTML><HEAD></HEAD><BODY><P>QV filter field is day (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31) and Expression Field is sales show day wise if user select date 1,2,3,4,5 then show avg sales Ex(Sales/5) </P></BODY></HTML> Tue, 22 Apr 2014 13:42:19 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604053#M1101622 vijayit43 2014-04-22T13:42:19Z Re: Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604054#M1101623 <HTML><HEAD></HEAD><BODY><P>Write like</P><P></P><P></P><P>Ex:-&nbsp; Sales / GetSelectedCount(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">day</SPAN>)</P><P></P><P>For Example:-</P><P></P><P>=&nbsp; ( Sum(YourSalesFieldHere) / GetSelectedCount(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">YourDayFieldHere</SPAN>) )</P></BODY></HTML> Tue, 22 Apr 2014 13:52:30 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604054#M1101623 its_anandrjs 2014-04-22T13:52:30Z Re: Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604055#M1101624 <HTML><HEAD></HEAD><BODY><P>You can simply write below in text box...</P><P></P><P>=AVG(Sales)</P></BODY></HTML> Tue, 22 Apr 2014 14:00:05 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604055#M1101624 MK_QSL 2014-04-22T14:00:05Z Re: Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604056#M1101625 <HTML><HEAD></HEAD><BODY><P>thanks,, its work for me....</P></BODY></HTML> Tue, 22 Apr 2014 14:21:48 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604056#M1101625 vijayit43 2014-04-22T14:21:48Z Re: Average in Qlikview https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604057#M1101626 <HTML><HEAD></HEAD><BODY><P>If you got solution from the thread so mark the thread as Correct / helpful.</P><P></P><P>Regards</P></BODY></HTML> Tue, 22 Apr 2014 14:25:05 GMT https://community.qlik.com/t5/QlikView/Average-in-Qlikview/m-p/604057#M1101626 its_anandrjs 2014-04-22T14:25:05Z