topic Re: Expression for Growth/Decline bar chart? in QlikView https://community.qlik.com/t5/QlikView/Expression-for-Growth-Decline-bar-chart/m-p/532882#M199068 <HTML><HEAD></HEAD><BODY><P>See attached example. Is that what you're looking for?</P></BODY></HTML> Wed, 18 Sep 2013 13:32:43 GMT Gysbert_Wassenaar 2013-09-18T13:32:43Z Expression for Growth/Decline bar chart? https://community.qlik.com/t5/QlikView/Expression-for-Growth-Decline-bar-chart/m-p/532881#M199067 <HTML><HEAD></HEAD><BODY><P>I need to make a bar chart that would simply have a bar for each month showing % growth or decline versus the previous month. So some bars should go negative, some positive. </P><P></P><P>I achieved a similar effect in a table using the expression:</P><P></P><P>RangeSum(sum([SALES]),-Before(sum([SALES])))/Before(sum([SALES]))</P><P></P><P>along with a date dimension.</P><P></P><P></P><P>This expression however does not display data in a bar chart for some reason, even though it says expression OK and I use the same dimension....</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 17 Sep 2013 18:25:03 GMT https://community.qlik.com/t5/QlikView/Expression-for-Growth-Decline-bar-chart/m-p/532881#M199067 2013-09-17T18:25:03Z Re: Expression for Growth/Decline bar chart? https://community.qlik.com/t5/QlikView/Expression-for-Growth-Decline-bar-chart/m-p/532882#M199068 <HTML><HEAD></HEAD><BODY><P>See attached example. Is that what you're looking for?</P></BODY></HTML> Wed, 18 Sep 2013 13:32:43 GMT https://community.qlik.com/t5/QlikView/Expression-for-Growth-Decline-bar-chart/m-p/532882#M199068 Gysbert_Wassenaar 2013-09-18T13:32:43Z