Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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
Author

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
Author

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
Specialist III
Specialist III

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.