topic Re: Full accumulation in expression in QlikView

Full accumulation in expression

Thu, 16 Feb 2012 18:48:14 GMT

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

Re: Full accumulation in expression

tresB — Thu, 16 Feb 2012 19:09:13 GMT

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

Fri, 25 Jan 2013 14:15:02 GMT

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

Fri, 25 Jan 2013 14:25:15 GMT

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

Re: Full accumulation in expression

nagaiank — Fri, 25 Jan 2013 16:11:27 GMT

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.