Help needed on cumulative range sum in Straight table

[Anonymous]

Hi All,

I need some advice on complex Range sum or set analysis expression which can accumulate Column 1 previous 12 records net value to be displayed in column2.

Here i am attaching example.

In the below excel is exported straight table from qlikview

Sum of 4A(Net Elgbl $) 12 months value is 643,910.565.26 but my expression returns incorrect value.

Can some one advice whats the wrong with formula or advice me if it is aggregating incorrectly.

4A(12M Elgbl $) Expression is

Sample qvw attached.

Appreciate your help

[Anonymous]

Hi ,

This is what i need, Can you send me the updated file what you have

[Anonymous]

Hi Swuehl,

This is what i need, Can you tell me what was the change in the expression?

Or send me updated file.

Thanks

[swuehl · Accepted solution]

See my previous post, applying only() with set expression around Ratio.

[Anonymous]

Thanks that works.

[Anonymous]

Hi

Can you see whats the wrong with my formula again when i select specific year then value not accumulated.

sum( aggr( rangesum( above(

(Sum({}ProductSales)

,0,12) ),NDC11,Period))

[swuehl]

sum( aggr( rangesum( above(

(Sum({}ProductSales)

,0,12) ),NDC11,Period))

This is your formula? Why should this accumulate over Year bounderies when you are not clearing selection in your calendar fields like in the previous expression. I would expect at least a set expression in the inner aggregation like

{<Year= >}

[or add up all calendar fields the user may select in].

[Anonymous]

Hi,

This is my Formula.

sum( aggr( rangesum( above(

((Sum({}ProductSales)

)

,0,12) ),NDC11,Period))