Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Polor1993
Contributor II
Contributor II

Line graph with Set Analysis and cumulative data

I need help to create a formula to a line chart. I want to create a chart using set analysis to specify a range of the axis x (I want just a sample of the dimension I selected), and at the same time I want it to be a cumulative line graph. For example:

Month                                  Value
November 2020                300
December 2020                150
January 2021                    250
February 2021                  175
March 2021                        450

In this example, I want my graph to cover only between December 2020 and March 2021 and to be cumulative, with 150 for December, 400 for January, 575 for February...

How can I create an expression for a line chart like that?

Thanks a lot!

Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

=RangeSum(Above(Sum({<Month={"*"}-{'November 2020'}>}Value),0,RowNo()))

BrunPierre_1-1667506822226.png

View solution in original post

2 Replies
BrunPierre
Partner - Master
Partner - Master

=RangeSum(Above(Sum({<Month={"*"}-{'November 2020'}>}Value),0,RowNo()))

BrunPierre_1-1667506822226.png

Polor1993
Contributor II
Contributor II
Author

Thanks! It really helped me. But just another question: do you know how can I apply the same expression but in order to always represent between the range of maximum month date until the last 12 months? I try to use the max function inside the set analysis, but I got confused how apply for this case.