Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Cumulative average

Hi All,

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.

Thank you

1 Solution

Accepted Solutions

Re: Re: Re: Cumulative average

Check enclosed file...

5 Replies

Re: Cumulative average

Sum separately qty (or amounts) and divide the total sum for the number of days

Hope it helps

Re: Cumulative average

Kindly provide sample data

Not applicable

Re: Re: Cumulative average

Hi Manish,

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.

Thanks

Re: Re: Re: Cumulative average

Check enclosed file...

Not applicable

Re: Re: Re: Cumulative average

Thank you Manish

Community Browser