topic Re: -- Chart cumulative data -- in QlikView

-- Chart cumulative data --

Fri, 27 Jul 2012 12:59:16 GMT

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.

CELAMBARASAN — Fri, 27 Jul 2012 13:03:52 GMT

Hi,

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

giakoum — Fri, 27 Jul 2012 13:04:17 GMT

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.

Fri, 27 Jul 2012 13:14:20 GMT

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?

Fri, 27 Jul 2012 13:21:12 GMT

I make this to illustrate the problem.

Thanks for help

nagaiank — Fri, 27 Jul 2012 13:25:27 GMT

Did you try calculating the cumulative values in the script?

Fri, 27 Jul 2012 13:32:36 GMT

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 — Fri, 27 Jul 2012 13:44:18 GMT

see attached

Fri, 27 Jul 2012 13:49:24 GMT

do that with sum expression:P

CELAMBARASAN — Fri, 27 Jul 2012 14:28:46 GMT

Chk with this