Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Store end amount of accumulation graph as a variable.

Hi community,  I have an line graph with full accumulation that has an ending value.  I put the same set analysis in a variable and for some reason it's slightly off.  All I want is the accumulation value with current selections stored as a variable.  Is there anayway to do this?

1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Store end amount of accumulation graph as a variable.

Assuming your chart dimension is something like Month, and your chart expression is Sum(Sales), try:

=Max(Aggr(RangeSum(Above(Sum(Sales),0,RowNo())),Month))

Hope this helps,

Jason

1 Reply
jason_michaelid
Honored Contributor II

Store end amount of accumulation graph as a variable.

Assuming your chart dimension is something like Month, and your chart expression is Sum(Sales), try:

=Max(Aggr(RangeSum(Above(Sum(Sales),0,RowNo())),Month))

Hope this helps,

Jason

Community Browser