Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Line averages

I have a chart that has many lines with amount an amount field.

I need to average the last three lines on each line.

Example:

Line             Amount         Average

1                         100                 0

2                         200                 0

3                         300            200.00

4                           33            177.66

6                           49            127.33

7                           74              52.00   

1 Solution

Accepted Solutions
MVP
MVP

Line averages

Try

=rangeavg( above( sum(Amount), 0, 3))

as Average expression. Lines should be sorted ascending in your chart.

Hope this helps,

Stefan

2 Replies
MVP
MVP

Line averages

Try

=rangeavg( above( sum(Amount), 0, 3))

as Average expression. Lines should be sorted ascending in your chart.

Hope this helps,

Stefan

MVP
MVP

Re: Line averages

Hi,

Please check attached file for solution.

Hope it helps you.

Regards,

Jagan.

Community Browser