# Qlik Sense App Development

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
Partner

## Rolling based last three months average sale

Hello,

i want to sum 3 last month on one month

For jan. 2019 i want to sum 7+11+7+19, how i can do this ?

the set analysis is : Sum( {\$<
FACT_Type = {"Mouvement"},
} _Qte_consommee_local)

Best regards,

Sophie

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Rolling based last three months average sale

May be you need one of these 2

```RangeSum(Below(Sum({\$<
FACT_Type = {"Mouvement"},
} _Qte_consommee_local), 0, 4))```

or this

`RangeSum(Below(Sum({\$<FACT_Type = {"Mouvement"}>} _Qte_consommee_local), 0, 4))`
3 Replies
Highlighted
Contributor II

## Re: Rolling based last three months average sale

HI,

You don't need to intersect set analysis for this propousal

``` Sum( {\$<
FACT_Type = {"Mouvement"},
} _Qte_consommee_local)```
Ag+
Highlighted
Partner

## Re: Rolling based last three months average sale

Hi,

Try these

=rangesum(above(Sum( {\$<
FACT_Type = {"Mouvement"},
} _Qte_consommee_local),0,3))

Regards

Mustaq

Highlighted
MVP

## Re: Rolling based last three months average sale

May be you need one of these 2

```RangeSum(Below(Sum({\$<
FACT_Type = {"Mouvement"},
`RangeSum(Below(Sum({\$<FACT_Type = {"Mouvement"}>} _Qte_consommee_local), 0, 4))`