# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:
Contributor

## Create a graph on evolution

Dear community,

I would like to create a dashboard on evolution but I have some problems regarding the formula

Regarding the following picture, I would like to create a graph with a curve of the evolution of my contracts

In January I have 50 new contracts and 30 cancellations. 50 new contracts - 30 cancellations = +20

In february I have 60 contracts - 30 cancellations = +30 (I would like to add also the +20 of january which means +50)

In march I have 50 contracts - 70 cancellations = -20 (Then I would like 50 - 20 = +30).

I tried the following dimensions :

=Dual(Year([date_signup])&'-'&Month([date_signup]),MonthStart([date_signup]))

I tried the following measures :

RangeSum(Above((Count({<[signup_plan_type]= {'plantype-standard'}>} [date_signup])),0, RowNo()))
-
RangeSum(Above((Count({<[signup_plan_type]= {'plantype-standard'}>} [date_cancelled])),0, RowNo()))

My graph is continually increasing. Therefore, there is a problem since I know there are months when there were more cancellations than new contracts

Thank you in advance for you help

Regards,

3 Replies
MVP

Hi,

Try like below

RangeSum(Above((Count({<[signup_plan_type]= {'plantype-standard'}>} [date_signup]) - Count({<[signup_plan_type]= {'plantype-standard'}>} [date_cancelled])),0, RowNo()))

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & likes if you like the post.
Contributor
Author

Hi Mayilvahanan,

I still have the same graph and the same problem with the formula you advised me.

Contributor
Author

Does anyone have any idea regarding ​​the formula?

Regards,

Tags
Community Browser