topic Cumulative Sum in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Sum/m-p/465081#M484577 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp; </P><P>I want to limit the dimension(Articles) till the value%<BR />column cumulates to &lt;= 20%&nbsp; starting from the lowest of ‘Trending<BR />SellThru’ column.</P><P></P><P>I tried it using the cumulative sum.</P><P></P><P>But I am unable to get the cumulative sum at division level.</P><P></P><P>Tried using dimension limit also but not working as required<BR />in this case.</P><P></P><P></P><P>Does anyone have any idea about it or may be a better sol’n.</P><P></P><P></P><P>Please refer the attachment.</P></BODY></HTML> Thu, 16 May 2013 07:28:38 GMT 2013-05-16T07:28:38Z Cumulative Sum https://community.qlik.com/t5/QlikView/Cumulative-Sum/m-p/465081#M484577 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp; </P><P>I want to limit the dimension(Articles) till the value%<BR />column cumulates to &lt;= 20%&nbsp; starting from the lowest of ‘Trending<BR />SellThru’ column.</P><P></P><P>I tried it using the cumulative sum.</P><P></P><P>But I am unable to get the cumulative sum at division level.</P><P></P><P>Tried using dimension limit also but not working as required<BR />in this case.</P><P></P><P></P><P>Does anyone have any idea about it or may be a better sol’n.</P><P></P><P></P><P>Please refer the attachment.</P></BODY></HTML> Thu, 16 May 2013 07:28:38 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum/m-p/465081#M484577 2013-05-16T07:28:38Z