Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Previous 30 rows average

Hi,

I would like to have the last 30 rows average froma table, any idea?

thank's

last 30 rows.jpg

1 Solution

Accepted Solutions
swuehl
MVP
MVP

in you straight table chart, try something like

=rangeavg( below( sum(TotalOrders), 1, 30) )

replacing sum(TotalOrders) with your expression.

View solution in original post

2 Replies
swuehl
MVP
MVP

in you straight table chart, try something like

=rangeavg( below( sum(TotalOrders), 1, 30) )

replacing sum(TotalOrders) with your expression.

ecabanas
Creator II
Creator II
Author

Manyyyy thank's