Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
bimartingo
Contributor III
Contributor III

Simple runnign sum question

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.

3 Replies
Anonymous
Not applicable

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
Contributor III
Contributor III
Author

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
Partner - Champion
Partner - Champion

Hi,

     Check with this do you need this type of solution.

     http://community.qlik.com/message/195158

Celambarasan