Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to Solution.
Check enclosed file...
Sum separately qty (or amounts) and divide the total sum for the number of days
Hope it helps
Kindly provide sample data
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.
Thank you Manish