Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
chinnakatikisg
Valued Contributor

Full Accumulation is not working in Trellis chart

Dear Friends,

I have a trellis Chart with daily Sales and Forecast values by showing separate chart for each product group and every small individual chart is being displayed at daily.is not showing accumulated total. Please find the attached image. If you see normal chart, accumulation is working where as in trellis it is not working.

Please suggest how to make accumulation works in trellis??

Br,

Chinna

1 Solution

Accepted Solutions
chinnakatikisg
Valued Contributor

Re: Full Accumulation is not working in Trellis chart

Dear Gysbert,

Thanks for your suggestion. I have managed to make it work in other way by sing below expression.

Also I have unchecked the "Full Accumulation" option after using the below expression). It is working fine in Trellis.

RangeSum(above(sum(Sales),0,RowNo()))

Br,

Chinna

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Full Accumulation is not working in Trellis chart

I think the only way is to create an AsOf table that links each day with all its previous days. See this blog post for more information: The As-Of Table


talk is cheap, supply exceeds demand
chinnakatikisg
Valued Contributor

Re: Full Accumulation is not working in Trellis chart

Dear Gysbert,

Thanks for your suggestion. I have managed to make it work in other way by sing below expression.

Also I have unchecked the "Full Accumulation" option after using the below expression). It is working fine in Trellis.

RangeSum(above(sum(Sales),0,RowNo()))

Br,

Chinna

View solution in original post