topic Re: Cumulative Average in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107230#M898033 <HTML><HEAD></HEAD><BODY><P>Is it working?</P></BODY></HTML> Tue, 02 Aug 2016 15:21:51 GMT sunny_talwar 2016-08-02T15:21:51Z Cumulative Average https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107227#M898030 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I need your help. I have a task that i need to find cumulative average for each month.</P><P>But in my data each month have different count of date,</P><P> i.e., In Jan only 10 days value are available and Feb only 21 days value are available in my data source. </P><P>How to find cumulative average? Please help me to solve this.</P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107227#M898030 yadhunandhanan 2020-11-25T16:16:04Z Re: Cumulative Average https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107228#M898031 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P><STRONG>RangeAvg(Above(Sum(Value), 0, DayField))</STRONG></P></BODY></HTML> Tue, 02 Aug 2016 11:32:19 GMT https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107228#M898031 sunny_talwar 2016-08-02T11:32:19Z Re: Cumulative Average https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107229#M898032 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny.</P></BODY></HTML> Tue, 02 Aug 2016 13:00:48 GMT https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107229#M898032 yadhunandhanan 2016-08-02T13:00:48Z Re: Cumulative Average https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107230#M898033 <HTML><HEAD></HEAD><BODY><P>Is it working?</P></BODY></HTML> Tue, 02 Aug 2016 15:21:51 GMT https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107230#M898033 sunny_talwar 2016-08-02T15:21:51Z Re: Cumulative Average https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107231#M898034 <HTML><HEAD></HEAD><BODY><P>Yes its working.</P></BODY></HTML> Wed, 03 Aug 2016 09:07:43 GMT https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107231#M898034 yadhunandhanan 2016-08-03T09:07:43Z Re: Cumulative Average https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107232#M898035 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Wed, 03 Aug 2016 11:31:37 GMT https://community.qlik.com/t5/QlikView/Cumulative-Average/m-p/1107232#M898035 oknotsen 2016-08-03T11:31:37Z