Discussion Board for collaboration related to Creating Analytics for QlikView.
I cant get range sum (above) to work properly. I am including the table below.
Amount column expression: =sum(Amount)
Amount (Rangesum above) expression: =rangesum(above(sum(Amount),0,12))
Amount Expected column: I added this to show how I would expect the range sum to work (current month plus accumlated total)
Basically I just want to accumulate the amount column but I must be writing the expression incorrectly.
Thanks in advance.
Go to Solution.
Thanks it worked! Can you explain the Row() part of this?
RowNo() function will itself return the row no u r on which secondary dimension within the first dimension eg: months within a year.
Whereas the RowNo(TOTAL) will ignore all the dimensions and returns the row no sequentially of a whole chart.
from online help
Returns the number of the current row within the current column segment in a table or, in the case of bitmap charts, within the chart's straight table equivalent. The first row is number 1.
If the table is one-dimensional or if the qualifier total is used as argument, the current column segment is always equal to the entire column.
above(sum(Amount),0,rowno()): n values, the current (0) and all preceding (above) rows
rangesum(...........) sum current and all preceding (above) rows