topic Unwanted accumlation in Chart in QlikView

Unwanted accumlation in Chart

Anonymous — Wed, 13 Feb 2013 08:33:59 GMT

Hi ALL,

I am using Full Accumlation feature for two expression working fine.

problem it show extended line when there is no value for that month is present.

i do not want this extended accumlation in line chart. attaching a example document.

Regards,

anant

Sokkorn — Wed, 13 Feb 2013 10:00:38 GMT

Hi anant,

Trt this IF(values='' OR IsNull(values),Null(),rangesum(above(Sum(values), 0, Rowno()))) and uncheck full accumulation.

Regards,

Sokkorn

Anonymous — Wed, 13 Feb 2013 10:09:51 GMT

Hi Sokkorn,

That works !!

Thanks

Anant