Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average of accumulated values, per day

Hi everyone,

I have a problem with the average of accumulated values, per day, in a pivot table.

For example:

Date               Values

01/08/2013 - U$400,00

02/08/2013 - U$500,00

03/08/2013 - U$300,00

04/08/2013 - U$400,00

05/08/2013 - U$400,00

06/08/2013 - U$500,00

Ok. And now, I want a expression to get the average of accumulated values, per day.

Like this:

Date               Values     Average of Accumulate Values

01/08/2013 - U$400,00                    U$400,00

02/08/2013 - U$500,00                    U$450,00

03/08/2013 - U$300,00                    U$400,00

04/08/2013 - U$800,00                    U$500,00

05/08/2013 - U$400,00                    U$440,00

06/08/2013 - U$600,00                    U$500,00

See? The expression will be some like "Accumulated values in that month until that day / number of days until date I want".

I don't know if my explanation is clear, but it's something like that. In the example with values, are more clear.

How can I do that? Have some way?

Thank you!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Try: RangeAvg(above(sum(Values),0,RowNo()))

The average for 05/08/2013 is 480 afaict though, not 440.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Try: RangeAvg(above(sum(Values),0,RowNo()))

The average for 05/08/2013 is 480 afaict though, not 440.


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Thank you man!!! Works perfectly!!