Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulate sales for months

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

10 Replies
Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi,

Please check the attached file for solution.

Regards,

Jagan.

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

Not applicable
Author

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.

qlik1.JPG

Not applicable
Author

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:

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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