Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unwanted accumlation in Chart

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  

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi anant,

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

Regards,

Sokkorn

View solution in original post

2 Replies
Sokkorn
Master
Master

Hi anant,

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

Regards,

Sokkorn

Anonymous
Not applicable
Author

Hi Sokkorn,

That works !!

Thanks

Anant