Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
Hi,
Check with this do you need this type of solution.
http://community.qlik.com/message/195158
Celambarasan