Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Average of last three Orders

I want to graph:

      - Dimension: Month

     - Expression: Average Order size of last three orders in that month.

I came to


Now how do i get it to only calculate the last three Orders of that month?

I read about FirstSortValue, but i am not sure how to use it in this context.


Community Browser