Discussion board where members can get started with QlikView.
What is the expression meaning?Please give an example.
Go to Solution.
This expression will sum every value into COUNT(PolicyCounter) from first column until current one
View solution in original post
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
Please explain with this example
Load * INLINE [S.No,PolicyCounter
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