Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK_QSL
MVP
MVP

Check enclosed file...

View solution in original post

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Hope it helps

MK_QSL
MVP
MVP

Kindly provide sample data

Not applicable
Author

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

MK_QSL
MVP
MVP

Check enclosed file...

Not applicable
Author

Thank you Manish