Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please explain what before function will do in expression : RangeSum(before(COUNT(PolicyCounter).
I did not understand the Help.
Thanks
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
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.
Hi,
Complete expression is this:
=if(COUNT(PolicyCounter) > 0,RangeSum(before(COUNT(PolicyCounter),0,ColumnNo())))
Please explain.
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