Rangesum with selection apply

[#1]

Hi All,

     Could anyone help me? I managed to apply rangesum formula using expression, and the result is right.

But why after then the selection doesn't work. I want to be able making selection based on report_period.

What did i missed? should it be done in load script?

Please see my attachement.

Thank you,

[robert_mika]

take the 1 off:

(RangeSum(Before(Sum({1<[Mov1]={"Addition", "Subtraction"}>} if(Mov1 = 'Subtraction', -Count, Count)),0, ColumnNo())))

1 tells the expression to ignore all selections

Feeling Qlikngry?

How To /Missing Manual(25 articles)

[#3]

Hi Robert,

It works!!

I should learn more about rangesum concept

Thanks,

[robert_mika]

Glad to hear but is  more about how Qlikview interpretation of

$ and 1/

Search forum for examples.

[sunny_talwar]

And in addition you can also go through this very comprehensive set analysis document. I learned a lot of things from this and I still continue to do.

[ahbzshk07]

that was good... (y)