Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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