Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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 accumulationsales
enero 100100
febrero15050
marzo20050
abril25050
mayo30050
junio35050
julio40050
agosto45050
septiembre50050
octubre55050

when i clik on junio, julio and agosto this happend

sales with full accumulationsales
junio5050
julio10050
agosto15050

but the real value should be:

real sales with full  accumulationsales
junio35050
julio40050
agosto45050

thanks for any advice.....

gerardo

4 Replies
MVP
MVP

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

Not applicable

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

Not applicable

Re: Full accumulation in expression

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

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.