https://community.qlik.com/t5/App-Development/Month-over-Month-Accumulation-Sum/m-p/1831707#M68585 Hi,<BR /><BR />Set analysis is used to restrict the result, not affect the aggregation. Could you please post your app to make it easier to look into this? Fri, 27 Aug 2021 09:24:19 GMT rbartley 2021-08-27T09:24:19Z https://community.qlik.com/t5/App-Development/Month-over-Month-Accumulation-Sum/m-p/1831614#M68578 <P>Hello community,&nbsp;</P><P>Is there a way to change the order of the dimensions using set analysis?</P><P>I need to display a month over month line graph in order to compare the values between different years.</P><P>The problem is that my measure is an accumulative sum from all prior periods, and when I use the Month as the first dimension, it accumulates wrongly as the lines are organized in a differente order, the example below will make it easier to understand:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gitguto_2-1630017220790.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60842i541A5EF5D7C8D5AB/image-size/medium?v=v2&amp;px=400" role="button" title="gitguto_2-1630017220790.png" alt="gitguto_2-1630017220790.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gitguto_0-1630017161034.png" style="width: 364px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60840i59762DA870E925E1/image-dimensions/364x196?v=v2" width="364" height="196" role="button" title="gitguto_0-1630017161034.png" alt="gitguto_0-1630017161034.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gitguto_1-1630017185761.png" style="width: 328px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60841i288AA4E75F2647A9/image-dimensions/328x303?v=v2" width="328" height="303" role="button" title="gitguto_1-1630017185761.png" alt="gitguto_1-1630017185761.png" /></span></P><P>&nbsp;</P><P>When I change the order of the Dimensions (Year first), the measure is calculated correctly, because the lines are organized in the right order, but I get the wrong visualization:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gitguto_3-1630017299127.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60843i03A4488261086AA6/image-size/medium?v=v2&amp;px=400" role="button" title="gitguto_3-1630017299127.png" alt="gitguto_3-1630017299127.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gitguto_4-1630017318102.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60844iB592F6706E9D110B/image-size/medium?v=v2&amp;px=400" role="button" title="gitguto_4-1630017318102.png" alt="gitguto_4-1630017318102.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gitguto_5-1630017356616.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60845i9433FFD35BA77EAC/image-size/medium?v=v2&amp;px=400" role="button" title="gitguto_5-1630017356616.png" alt="gitguto_5-1630017356616.png" /></span></P><P>&nbsp;</P><P>Is there a way to have the first visualization with the right accumulation sum?</P><P>&nbsp;</P> Thu, 26 Aug 2021 23:06:02 GMT https://community.qlik.com/t5/App-Development/Month-over-Month-Accumulation-Sum/m-p/1831614#M68578 gitguto 2021-08-26T23:06:02Z https://community.qlik.com/t5/App-Development/Month-over-Month-Accumulation-Sum/m-p/1831707#M68585 Hi,<BR /><BR />Set analysis is used to restrict the result, not affect the aggregation. Could you please post your app to make it easier to look into this? Fri, 27 Aug 2021 09:24:19 GMT https://community.qlik.com/t5/App-Development/Month-over-Month-Accumulation-Sum/m-p/1831707#M68585 rbartley 2021-08-27T09:24:19Z