Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.