topic Full accumulation in charts in QlikView

Full accumulation in charts

Anonymous — Thu, 06 Jan 2011 21:15:13 GMT

I have a problem with full accumulation in a chart.

It seams that I only can accumulate over max 100 dimension values, even if i have maked a check in "Full Accumulation".

I like to se a accumulated saldo of a balance sheet account over a year where my dimension is date. And since I have 365 days in a year, I get the problem. Its only the first 100 days that gives me the correct value.

Any sugestions?

Henrik

Full accumulation in charts

pover — Thu, 06 Jan 2011 21:29:41 GMT

Have you tried to use a rangesum() function with an above() or before() function to accumulate amounts between rows? Here's an example:

rangesum(above(sum(Sales),0,365))

You can replace the 365 with a expression that counts the number of days you have like the following expression.

rangesum(above(sum(Sales),0,max(total Date)-min(total Date)+1))

Regards.

Full accumulation in charts

johnw — Thu, 06 Jan 2011 23:47:27 GMT


henrikmatz wrote:It seams that I only can accumulate over max 100 dimension values, even if i have maked a check in "Full Accumulation".

Works fine for me. See attached. 365 days, every day with 1 sale, full accumulation. The graph smoothly climbs through the entire year. Am I misunderstanding your problem?

Full accumulation in charts

Anonymous — Fri, 07 Jan 2011 12:51:21 GMT

Thanks John and Karl,

It might be because my measure is a Set.

I will work a litle more with the problem a see if i can find a solution. Its a bit strange.

Unfortunately the workbook is confidential, so i cannot publish it.

Henrik

Full accumulation in charts

Anonymous — Fri, 07 Jan 2011 17:52:42 GMT

Ok i found the problem but not the solution.

The problem is that there are more dimension values that can be shown inside the width of my chart.

Any sugestions, cause i would like to have a fixed width in my solution?

Full accumulation in charts

Anonymous — Fri, 07 Jan 2011 18:13:18 GMT

Ok there was a nice solution.

I just checked the property "Continous". (Axes-properties).

That solved my problem.

Case closed.