Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
anyone can send me the sample qvw for the usage of above and rangesum functon () on bar charts???
Hi,
Here's an example in a straight table. You can switch it to a bar chart if you wish to see it in that format. I've also attached an excel in case you cannot open the qvw. Set expressions are shown in the column headers.
Here's the expression: rangesum(above(sum(sales),0,4))
It sums sales over 4 rows of data begining in the current row.
Hope that helps.
Matt