topic Re: Cumilative evolution in QlikView

Cumilative evolution

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all,

if i want to show a line chart that shows a cumilative amount evolution by month-year

ex: jan-2016 5000

Feb-2016. 4000

need to show on a line chart :

jan-2016. 5000

feb-2016. 9000

hope you can help

thank you

‌

Re: Cumilative evolution

Chanty4u — Sun, 20 Mar 2016 11:33:47 GMT

hi,

rangesum(above(sum({$< yearmonth={'value'}>}filed),0,rowno()))

Re: Cumilative evolution

Chanty4u — Sun, 20 Mar 2016 11:37:59 GMT

or else

Select Full Accumulation in the expressions tab of the chart!

Cumulative Line Chart

Re: Cumilative evolution

mario-sarkis — Sun, 20 Mar 2016 12:15:58 GMT

‌is this work for the whole year ? since as i can see i have to put the value of yearmonth

Re: Cumilative evolution

sunny_talwar — Sun, 20 Mar 2016 14:21:43 GMT

Would you be accumulating it for just the year and then on January the accumulation resets? Is that your goal?

Re: Cumilative evolution

mario-sarkis — Sun, 20 Mar 2016 20:02:11 GMT

‌hi sunny yes exactly is this possible? But i can still see it aa cumulative in the previous year?

Re: Cumilative evolution

sunny_talwar — Sun, 20 Mar 2016 20:04:30 GMT

I think this is possible, let me see if I can get a sample for you.

Re: Cumilative evolution

sunny_talwar — Sun, 20 Mar 2016 20:15:34 GMT

Something like this?

Sample Script used:

Table:

LOAD Date,

Month(Date) as Month,

Num(Month(Date)) as MonthNum,

Year(Date) as Year,

MonthName(Date) as MonthYear,

Sales;

LOAD Date(MakeDate(2009, 12, 31) + RecNo()) as Date,

Ceil(Rand() * 100) * 10 as Sales

AutoGenerate Today() - MakeDate(2009, 12, 31);

Expression: =RangeSum(Above(Sum(Sales), 0, MonthNum))

Dimension: MonthYear