topic Simple runnign sum question in QlikView

Simple runnign sum question

bimartingo — Mon, 27 Feb 2012 19:50:31 GMT

I have a table with list of sales data (store, month_of_sale, value)

i want to put on a graph the sales values and on year acumulated sales values, month by month.

if i would build a table with this data to show it on a bar chart , each row in this table would be like this:

( store, month_of_sale, value, sum(value where month_of_sale between first_month_of_the_year and current month_of_sales) )

Example:

( Store_1, jan/2011,1000, 1000 )

( Store_1, feb/2011, 2000, 3000 )

( Store_1,mar/2011,3000, 6000 )

How would i build the expression for this 3rd expression? I saw a lot of examples with rangesum, below, before, but it's quite unclear for me.

Anonymous — Mon, 27 Feb 2012 21:13:22 GMT

Hi Bimartingo,

Have you tried to use the option full accumulation on the tab expression?

Kind regards,

Henco

EDIT: find attached a sample file

Message was edited by: hencovanee

bimartingo — Tue, 28 Feb 2012 11:19:13 GMT

Henco,

you are right, but suppose the case where you have to different fiscalyears and you want to restart the total for each year. like this:

( Store_1, jan/2010,1000, 1000 )

...

( Store_1,dec/2010,1000, 12000 )

( Store_1, jan/2011,1000, 1000 )

( Store_1, feb/2011, 2000, 3000 )

( Store_1,mar/2011,3000, 6000 )

The acummulation should restart in the mittle.

CELAMBARASAN — Tue, 28 Feb 2012 11:38:03 GMT

Hi,

Check with this do you need this type of solution.

Celambarasan