Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
arethaking
Contributor II

What is the expression meaning?

What is the expression meaning?Please give an example.

RangeSum(before(COUNT(PolicyCounter),0,ColumnNo()))

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: What is the expression meaning?

This expression will sum every value into COUNT(PolicyCounter) from first column until current one

View solution in original post

4 Replies
Employee
Employee

Re: What is the expression meaning?

This expression will sum every value into COUNT(PolicyCounter) from first column until current one

View solution in original post

Frank_Hartmann
Honored Contributor II

Re: What is the expression meaning?

hi Aretha,

it calculates the cumulative sum of counts in pivot table.

in chart or a straight table you would use "above" instead of "before".

hope that helps

arethaking
Contributor II

Re: What is the expression meaning?

Please explain with this example

Load * INLINE [S.No,PolicyCounter

1,2

2,12

3,34

4,89

5,80

]

Re: What is the expression meaning?

It seems like an expression used in a pivot table where you are accumulating based on your pivoted dimension. So assuming S.No as your dimension, you will get something like this.

S.No               1     2     3     4     5

ExpResult       2     14   48   137  217