topic Re: Plotting consecutive sum values in chart in QlikView

Plotting consecutive sum values in chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

The above sample data should be plotted in a Line Chart in way values sum up for each day. More like a Fibonacci series.

This should be my resultant table data

Category	Date	Value	NewValue
A	01-Oct-2016	2	2
A	02-Oct-2016	3	5
A	03-Oct-2016	1	6
A	04-Oct-2016	5	11
A	05-Oct-2016	4	15

Is there a way to do this? Solutions for both at the script level or front end level (Using Expressions) would do the need.

lakshmikandh — Tue, 11 Oct 2016 07:20:46 GMT

Anil_Babu_Samineni — Tue, 11 Oct 2016 09:36:45 GMT

Perhaps this

Using Straight Table

Take Dimension --> Category, Date

Expressions are

1) Sum(Value)

2) Rangesum(Below(Sum(Value),0),Above(Value,1,4))

And Second Expression, If you have more Category, Dates then for safety you can give Value like below

Rangesum(Below(Sum(Value),0),Above(Value,1,1000))

For Ref, PFA

sunny_talwar — Tue, 11 Oct 2016 10:40:28 GMT

How long does accumulation restarts at the end of the month of end of the year? I am guessing it does restart for each category, right?

MarcoWedel — Tue, 11 Oct 2016 23:14:50 GMT

Hi,

one front end solution could be the chart-in-built accumulation option:

hope this helps

regards

Marco