4 Replies Latest reply: Jan 25, 2013 11:11 AM by Nagaian Krishnamoorthy

# Full accumulation in expression

Hi everyone!

i have a problem in a chart which has one metric with full accumulation check enable. The problem is when i select two or three months the original values change.

ej.:

 sales with Full accumulation sales enero 100 100 febrero 150 50 marzo 200 50 abril 250 50 mayo 300 50 junio 350 50 julio 400 50 agosto 450 50 septiembre 500 50 octubre 550 50

when i clik on junio, julio and agosto this happend

 sales with full accumulation sales junio 50 50 julio 100 50 agosto 150 50

but the real value should be:

 real sales with full  accumulation sales junio 350 50 julio 400 50 agosto 450 50

gerardo

• ###### Re: Full accumulation in expression

I think what you want should be done at the backend using PEEK function or something like that, otherwise based on selection, this is normal behavior. or if you have transaction date, you probably can use SET which would let you make difference in normal selection behavior.

Regards,  tresesco

• ###### Re: Full accumulation in expression

Hi Gerardo,

Qlikview beginner here. I realise this post was nearly a year but I've been having trouble finding a solution to this very problem you have descibed for some time now. Did you ever solve this? Any suggestion would be of great help to me.

Regards,

Andrew

• ###### Re: Full accumulation in expression

=aggr(

rangesum( above(Count(DISTINCT{\$<SUBSCRIPTIONS.is_subscribed = {'1'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>}SUBSCRIPTIONS.email)

-Count(DISTINCT{\$<SUBSCRIPTIONS.is_subscribed = {'0'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>}SUBSCRIPTIONS.email),0,rowno()))

, CALENDARIO_SUBSCRIPTIONS.AñoMes)

i couldn't understand the expresion at all, the community help to build it.

regards

gerardo

• ###### Re: Full accumulation in expression

If you want the cumulative sales not afected by month selection, you need to get the cumulative values in the script.

Here is an example of doing this. This solution is based on a previous post in the forum.