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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. 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