topic Re: Accumulate sales for months in QlikView

Accumulate sales for months

Fri, 23 Mar 2012 20:54:27 GMT

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

Accumulate sales for months

Fri, 23 Mar 2012 21:40:07 GMT

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

Re: Accumulate sales for months

jagan — Sat, 24 Mar 2012 06:09:27 GMT

Hi,

Please check the attached file for solution.

Regards,

Jagan.

Re: Accumulate sales for months

Mon, 26 Mar 2012 14:32:18 GMT

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

Accumulate sales for months

jagan — Mon, 26 Mar 2012 14:36:18 GMT

Hi,

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

Regards,

Jagan.

Accumulate sales for months

Mon, 26 Mar 2012 19:31:34 GMT

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.

Re: Accumulate sales for months

Mon, 26 Mar 2012 20:51:33 GMT

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:

Re: Accumulate sales for months

Mon, 26 Mar 2012 21:19:44 GMT

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])

Re: Accumulate sales for months

Tue, 27 Mar 2012 14:41:57 GMT

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

Re: Accumulate sales for months

Tue, 27 Mar 2012 14:42:34 GMT

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

Accumulate sales for months

Tue, 27 Mar 2012 16:34:41 GMT

Hi.

Where I can Find a manual about make expressions for example

sum(if (InYearToDate (, and more command

Thank alot