topic Accumulation Problem (Bar Chart) in QlikView

Accumulation Problem (Bar Chart)

piotrekd — Thu, 07 Apr 2011 14:56:09 GMT

Hi,

Can anybody explain me why calculations from my bar chart are different from what i excpect to see ?

I want to see current difference between years in accumulation mode. Value is correct only for first quarter.

Example application in attachment. Any suggestions are welcome!

Thanks, Piotr

Accumulation Problem (Bar Chart)

Thu, 07 Apr 2011 15:13:45 GMT

Hi buddy,

I guess that your informations are accumulated.
Look on graphic properties - expression - Accumulate (on down and left of window).

bye

Accumulation Problem (Bar Chart)

piotrekd — Thu, 07 Apr 2011 15:26:32 GMT

Yes, it is accumulated because I expect this kind of analysis, but %Change is not correct.

In Q2 it should be 34,09% instead 68,33%.

If I uncheck accumulation I would see only comparison of single quarters, but I need comparison of accumulated data.

Regards,

Piotr

Accumulation Problem (Bar Chart)

piotrekd — Fri, 08 Apr 2011 13:52:10 GMT

I've found solution - more complex but working.

I disabled accumulation option for all expressions and use Above() function to accumulate values in the same way.

I think that accumulation option caused the problem, because calculation of expression was performed for every value of dimension (Q1, Q2..) and the results were summed.

Expressions are not so simple as it could be using accumulation mode in chart, so if somebody know simpler solution (simpler expressions or other solution) to obtain such an effect as above, please let me know.

File with my solution in attachment.

Regards, Piotr