topic Re: Cumulative average in QlikView https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581998#M477303 <HTML><HEAD></HEAD><BODY><P>Sum separately qty (or amounts) and divide the total sum for the number of days</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 30 Apr 2014 12:13:16 GMT alexandros17 2014-04-30T12:13:16Z Cumulative average https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581997#M477302 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How can I calculate a cumulative (by date) average in qlikview. If i tick cumulate in expressions, it just adds all the averages together. I would like to see a ytd average for each day.</P><P></P><P>Thank you</P></BODY></HTML> Wed, 30 Apr 2014 12:11:00 GMT https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581997#M477302 2014-04-30T12:11:00Z Re: Cumulative average https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581998#M477303 <HTML><HEAD></HEAD><BODY><P>Sum separately qty (or amounts) and divide the total sum for the number of days</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 30 Apr 2014 12:13:16 GMT https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581998#M477303 alexandros17 2014-04-30T12:13:16Z Re: Cumulative average https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581999#M477304 <HTML><HEAD></HEAD><BODY><P>Kindly provide sample data</P></BODY></HTML> Wed, 30 Apr 2014 12:19:16 GMT https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/581999#M477304 MK_QSL 2014-04-30T12:19:16Z Re: Re: Cumulative average https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/582000#M477305 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Please find attached some dummy data. Columns A to E is the source data, and what I am effectively trying to calculate is column O.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 30 Apr 2014 13:43:22 GMT https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/582000#M477305 2014-04-30T13:43:22Z Re: Re: Re: Cumulative average https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/582001#M477306 <HTML><HEAD></HEAD><BODY><P>Check enclosed file...</P></BODY></HTML> Wed, 30 Apr 2014 14:51:50 GMT https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/582001#M477306 MK_QSL 2014-04-30T14:51:50Z Re: Re: Re: Cumulative average https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/582002#M477307 <HTML><HEAD></HEAD><BODY><P>Thank you Manish</P></BODY></HTML> Fri, 02 May 2014 09:28:05 GMT https://community.qlik.com/t5/QlikView/Cumulative-average/m-p/582002#M477307 2014-05-02T09:28:05Z