Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Re: -- Chart cumulative data --

9 Replies

Re: -- Chart cumulative data --

Hi,

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

Partner
Partner

Re: -- Chart cumulative data --

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

Re: -- Chart cumulative data --

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

Re: -- Chart cumulative data --

I make this to illustrate the problem.

Thanks for help

nagaiank
Valued Contributor III

Re: -- Chart cumulative data --

Did you try calculating the cumulative values in the script?

Not applicable

Re: -- Chart cumulative data --

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?

Partner
Partner

Re: -- Chart cumulative data --

see attached

Not applicable

Re: -- Chart cumulative data --

do that with sum expression:P

Re: -- Chart cumulative data --