Accumulate sales for months

[#1]

I have the sales for each year en months, How I accumulate the sales for Months, for example January $ 1000.00, Feb 3000.00, Mar 2000.00, in a simple table.

Vendor     Month     Year 2012    Accumulate

XXXXX          Jan          1000          1000

                   Feb         3000          4000

                   Mar         2000          6000

Thank A lot

[#2]

Hi Mario,

use for ex. a straight table with (any Dims and) two expressions like:

first expr. Label = Year2012

sec expr. Label = Accu

first expression = values to add

sec. expression = rangesum([Year2012], Above([Accu]))

Regards,

Roland

[jagan]

Hi,

Please check the attached file for solution.

Regards,

Jagan.

[#4]

Hi Jagan.

I didn’t recibe the attach file.

Regards

Saludos

Mario Diaz Parham

Jefe Informática

Grupo Midence Soto Pierrefeu

Tel. (504) 2280 32 57

De: jagan mohan

Enviado el: Sábado, 24 de Marzo de 2012 12:10 a.m.

Para: Mario Diaz Parham

Asunto: - Re: Accumulate sales for months

<http://community.qlik.com/index.jspa> QlikCommunity

Re: Accumulate sales for months

created by jagan mohan <http://community.qlik.com/people/jagan> in Development (QlikView Desktop) - View the full discussion <http://community.qlik.com/message/203960#203960

[jagan]

Hi,

Check the attachment in previous post.  I am able to view it in my previous post.

Regards,

Jagan.

[#6]

Hi.

I Have Tried with your Advice but didn't work.

I have a field [Ventas Netas] this is my field with the sales.

I use =RangeSum(Sum([Ventas - Netas]), Above ([Accu]) but the result is the same that Sum([Ventas - Netas])

Regards.

[#7]

Hi Mario,

the function rangesum() restarts from 0 for every new combination of your dimensions. This is in your case "Vendedor" and "Mes". If you remove (for testing) one of the dimensions your expression should work as you expect it. As describing this isn't that easy, take a look at my example:

[#8]

Hi Mario,

sorry, I was too fast with my posting above. I forgot the "Total" in my last chart. I your case in the above() - function this should work with the TOTAL-qualifier:

=RangeSum(Sum([Ventas - Netas]), Above ( TOTAL [Accu])

RR

[#9]

Thanks alot

Saludos

Mario Diaz Parham

Jefe Informática

Grupo Midence Soto Pierrefeu

Tel. (504) 2280 32 57

De: Roland Kunle

Enviado el: Lunes, 26 de Marzo de 2012 03:20 p.m.

Para: Mario Diaz Parham

Asunto: - Re: Accumulate sales for months

<http://community.qlik.com/index.jspa> QlikCommunity

Re: Accumulate sales for months

created by Roland Kunle <http://community.qlik.com/people/kurokarl> in Development (QlikView Desktop) - View the full discussion <http://community.qlik.com/message/204473#204473

[#10]

Thank alot

Saludos

Mario Diaz Parham

Jefe Informática

Grupo Midence Soto Pierrefeu

Tel. (504) 2280 32 57

De: Roland Kunle

Enviado el: Lunes, 26 de Marzo de 2012 02:52 p.m.

Para: Mario Diaz Parham

Asunto: - Re: Accumulate sales for months

<http://community.qlik.com/index.jspa> QlikCommunity

Re: Accumulate sales for months

created by Roland Kunle <http://community.qlik.com/people/kurokarl> in Development (QlikView Desktop) - View the full discussion <http://community.qlik.com/message/204464#204464