Before function

[arethaking]

Hi All,

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

I did not understand the Help.

Thanks

[Gysbert_Wassenaar]

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.

[arethaking]

Hi,

Complete expression is this:

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

Please explain.

[boorgura · Accepted solution]

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