Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Check enclosed file...
Thank you Manish