topic Re: Rangesum with selection apply in QlikView

Rangesum with selection apply

Sat, 19 Dec 2015 19:55:08 GMT

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,

Re: Rangesum with selection apply

robert_mika — Sun, 20 Dec 2015 08:35:11 GMT

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)

Re: Rangesum with selection apply

Sun, 20 Dec 2015 10:22:24 GMT

Hi Robert,

It works!!

I should learn more about rangesum concept

Thanks,

Re: Rangesum with selection apply

robert_mika — Sun, 20 Dec 2015 22:08:44 GMT

Glad to hear but is more about how Qlikview interpretation of

$ and 1/

Search forum for examples.

Re: Rangesum with selection apply

sunny_talwar — Sun, 20 Dec 2015 23:54:55 GMT

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.

Re: Rangesum with selection apply

ahbzshk07 — Mon, 21 Dec 2015 07:36:40 GMT

that was good... (y)