Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Champion
Champion

Hi,

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

Read this:

RangeSum - script and chart function ‒ Qlik Sense

View solution in original post

1 Reply
YoussefBelloum
Champion
Champion

Hi,

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

Read this:

RangeSum - script and chart function ‒ Qlik Sense