Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Franco2
Contributor II
Contributor II

RANGESUM with two dimension

Hi,

I have the following graphs:

Franco2_1-1650267577526.png

1,2 and 3 are correct.

The first one shows my variable SPEND by months and the second shows it's division by the dimension SEG.

The formula in both is the same: Sum(SPEND).

Now I want to show the movile sum of the variable SPEND in a six months term.

 

The third graph shows it without any other partition and it works perfectly. The formula is 

rangeSUM(above(sum(SPEND),0,6))

But when I want to open it by the dimension SEG (4TH GRAPH ) it doesn't work properly. I've tried with the following formula:

AGGR(rangeSUM(above(sum(SPEND),0,6)),SEG,Month)

but it also doesn't work.

The 4th graph should look like this:

 

Franco2_3-1650268017783.png

Thank you in advance!!

 

Labels (6)
0 Replies