Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

moslem_teymoori
Contributor

How to sum up the values in a period of time and show the evolution in graph?

Hi guys, hope you are in a tip-top shape

I have problem with summing up the values and showing them in the graph.  i want to sum up day by day ( for example showing a value for today as the start point, for tomorrow it should be the summation of today's value and tomorrow's value , and for the third day it should be the summation of the first two days plus the third day so on, so the trends must be increasing  ).

the graph has 3 parameters , 2 parameter for the X axis and the value for the Y axis.

in the X axis one of the parameters is date and the other one is the materials which owns the values. the filed for the material is called Tipo which shows the Type of materials (F&L).

would you please help me how to do this summation? for different type

The screenshot is attached. Cattura.JPG

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: How to sum up the values in a period of time and show the evolution in graph?

Hi,

you need to user RangeSum() function with above () function.

Read this:

RangeSum - script and chart function ‒ Qlik Sense

1 Reply
YoussefBelloum
Esteemed Contributor

Re: How to sum up the values in a period of time and show the evolution in graph?

Hi,

you need to user RangeSum() function with above () function.

Read this:

RangeSum - script and chart function ‒ Qlik Sense

Community Browser