Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Rangesum with selection apply

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,

5 Replies
Highlighted

Re: Rangesum with selection apply

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)

Highlighted
Not applicable

Re: Rangesum with selection apply

Hi Robert,

It works!!

I should learn more about rangesum concept

Thanks,

Highlighted

Re: Rangesum with selection apply

Glad to hear but is  more about how Qlikview interpretation of

$ and 1/

Search forum for examples.

Highlighted

Re: Rangesum with selection apply

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.

Highlighted
ahbzshk07
New Contributor III

Re: Rangesum with selection apply

that was good... (y)