Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Charts

anyone can send me the sample qvw for the usage of above and rangesum functon () on bar charts???

1 Reply
Not applicable
Author

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