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

-- Chart cumulative data --

Hello,

I have a problem about the accumulation in a chart :

the dimension is : MonthName

the expression is :  count(NUMBER_SALES)    with full accumulation 

but when I click to select just the 3 last months the accummulation change so i dont have the same result.

Anyone have an idea ?

See the example file attached to illustrate the problem.

Thanks in advance.

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

9 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Accumulation computes the calculation based on the values displayed in that table.

giakoum
Partner - Master II
Partner - Master II

accumulation sums what is on the chart.

you should use something like count({1<[MonthName]={"<$(=only(minstring(MonthName)))"}>} [NUMBER_SALES]) + count(NUMBER_SALES)

so that you can have previous months count regardless of what is selected.

Not applicable
Author

Hello,

I try a set analysis but this doesn't work.

With your expression I can't zoom :  MonthNames can't change in the chart.

Maybe you have another idea?

Not applicable
Author

I make this to illustrate the problem.

Thanks for help

nagaiank
Specialist III
Specialist III

Did you try calculating the cumulative values in the script?

Not applicable
Author

If I calculate the cumulative values in the script, i can't use filter on these values.no?

Maybe if I have another field like "Name"

and I want to see the cumul just about 1 man how I do?

giakoum
Partner - Master II
Partner - Master II

see attached

Not applicable
Author

do that with sum expression:P

CELAMBARASAN
Partner - Champion
Partner - Champion

Chk with this