Discussion Board for collaboration related to QlikView App Development.
I am looking for a way to get an average amount per day of the month over the last 12 months. For example, I would need to sum the amount on 12/1, 1/1, 2/1, etc. and average that number. I would need to do that for every day. Any help on this would be greatly appreciated.
Thanks in advance!
May be this
Sunny, don't you mean:
Not sure I am clear if OP wants to do Avg each day and then sum or sum each day and then average.... but you could be right
I would want to sum every day (12/1, 1/1, 2/1) and then average
Then jontydkpi's response is the right one I guess
try a straight table with calculated dimension
How would I just grab the last 12 months?
Are you trying to get rolling 12 months?