Full accumulation in expression

[#1]

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

thanks for any advice.....

gerardo

[tresesco]

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

[#3]

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

[#4]

Hi Andrew...may be this help you....is for other issue i had...

=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

[nagaiank]

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.