Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
Partner

9 Replies
CELAMBARASAN
Partner
Partner

Hi,

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

giakoum
Partner
Partner

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
Partner

see attached

Not applicable
Author

do that with sum expression:P

CELAMBARASAN
Partner
Partner