Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
arethaking
Contributor II

Before function

Hi All,

Please explain what before function will do in expression : RangeSum(before(COUNT(PolicyCounter).

I did not understand the Help.

Thanks

1 Solution

Accepted Solutions
boorgura
Valued Contributor

Re: Before function

I believe the expression is trying to achieve cumulative values.

For example - Jan - Jan total

Feb - Jan + Feb total

March - Jan + Feb + March total...

and so on

3 Replies
MVP & Luminary
MVP & Luminary

Re: Before function

If you are unable to find the help file you can also use the online help: Before ‒ QlikView

It won't do anything because the expression is missing two closing parentheses. Even if you add those it will just return the count of PolicyCounter of the previous column i.e the column below the one where you get the result.


talk is cheap, supply exceeds demand
arethaking
Contributor II

Re: Before function

Hi,

Complete expression is this:

=if(COUNT(PolicyCounter) > 0,RangeSum(before(COUNT(PolicyCounter),0,ColumnNo())))

Please explain.

boorgura
Valued Contributor

Re: Before function

I believe the expression is trying to achieve cumulative values.

For example - Jan - Jan total

Feb - Jan + Feb total

March - Jan + Feb + March total...

and so on