topic Re: Cumulative growth line in Visualization and Usability

Cumulative growth line

Qlik_Bio06 — Wed, 22 Dec 2021 16:30:39 GMT

Hi,

How to create a cumulative growth line that increases by 2.2 million per month?

Where can I enter the increase of 2.2 million?

Can someone help me or give me a tip?

Grretings

Ebi

Re: Cumulative growth line

Dalton_Ruer — Fri, 09 Apr 2021 18:29:53 GMT

You can use an expression like RowNo()*2.2 million as the line in the Combo Chart

If you want the 2.2 million to be dynamic just create a variable and use dollar sign expansion in the formula to get the value of the variable: =RowNo() * $(vVariable)

You can use the Variable Input object from the Qlik Dashboard Bundle to allow the end user to modify the variable.

Re: Cumulative growth line

mato32188 — Fri, 09 Apr 2021 18:41:59 GMT

Hi @Qlik_Bio06,

instead of using Bar chart - Add-Ons - Reference Lines go for Combo Chart with dims and measures only.

Dim: Month(Created on)

Measure: rangesum(above(sum(2200000),NoOfRows())) - gives you cummulative of 2.2 mil for every Month(created on)

Re: Cumulative growth line

Qlik_Bio06 — Tue, 13 Apr 2021 12:21:21 GMT

Many thanks for the help. The 2.2 million should remain fixed for the time being. That should be okay now, right?

The chart shows the sales(CHF) for 2020 and then again the sales(CHF) accumulated.
How can I display the sales from the current year only?I don't currently have the data from 2021, but I wanted it to be an example for 2020
Is it correct?
SUM ({$ <Year = {'$ (= Year (Today ()) - 1)'}>} CHF) 2020
SUM ({$ <Year = {'$ (= Year (Today ()))'}>} CHF) 2021

Re: Cumulative growth line

Qlik_Bio06 — Tue, 13 Apr 2021 12:25:04 GMT

At the moment I'm also filtering some data using expression. What is the best solution here? Any suggestions?

Re: Cumulative growth line

Qlik_Bio06 — Tue, 13 Apr 2021 12:25:40 GMT

Many thanks for the help. The 2.2 million should remain fixed for the time being. That should be okay now, right?