Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
Not applicable

Range Average Qlikview

I am trying to calculate a moving average for customers. I want my table to show me the average of each customer based on his previous months data available. When I make a selection of a particular customer the table works fine. But problem arises when there is no selection on Contract. The table does not aggregate the moving average w.r.t to Customers. The query that i am currently using, which works fine for each Contract when selected, is:

Rangeavg(Above(TOTAL Sum(UnitBilled), 1, Rowno(TOTAL)))

However when there is no selection made the table shows the following details:

For each contract i want the table to show his own moving average. Like it is doing so for A in the above table.

Thanks!

Tags (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Range Average Qlikview

Try removing the totals from the expression so the rangeavg does not cross the borders of the contact dimension:

Rangeavg(Above(Sum(UnitBilled), 1, Rowno()))


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Range Average Qlikview

Try removing the totals from the expression so the rangeavg does not cross the borders of the contact dimension:

Rangeavg(Above(Sum(UnitBilled), 1, Rowno()))


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Re: Range Average Qlikview

thank you Gysbert, it worked!