topic Re: Stacked bar Graph using proportion function in QlikView https://community.qlik.com/t5/QlikView/Stacked-bar-Graph-using-proportion-function/m-p/870514#M1014139 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this expression for your chart.</P><P>=sum( Data)/sum( TOTAL &lt;ProjYear&gt; Data)</P></BODY></HTML> Tue, 21 Apr 2015 05:50:43 GMT SergeyMak 2015-04-21T05:50:43Z Stacked bar Graph using proportion function https://community.qlik.com/t5/QlikView/Stacked-bar-Graph-using-proportion-function/m-p/870513#M1014138 <HTML><HEAD></HEAD><BODY><P>Hello Team,</P><P></P><P>I have posted this 5 days back but no reply has come. Please help me out regarding this.</P><P>Scenario :</P><P>I have one complex problem where I need to show the Stacked bar chart in Qlikview using the Data in Excel.For&nbsp; Reference I have provided both the stacked bar graphs and the excel data in the attached Excel file.</P><P>Please help me out regarding this as it is urgent.</P><P>Logic is explained in the excel itself.</P><P></P><P>Regards,</P><P>Hari</P></BODY></HTML> Tue, 21 Apr 2015 05:32:44 GMT https://community.qlik.com/t5/QlikView/Stacked-bar-Graph-using-proportion-function/m-p/870513#M1014138 2015-04-21T05:32:44Z Re: Stacked bar Graph using proportion function https://community.qlik.com/t5/QlikView/Stacked-bar-Graph-using-proportion-function/m-p/870514#M1014139 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this expression for your chart.</P><P>=sum( Data)/sum( TOTAL &lt;ProjYear&gt; Data)</P></BODY></HTML> Tue, 21 Apr 2015 05:50:43 GMT https://community.qlik.com/t5/QlikView/Stacked-bar-Graph-using-proportion-function/m-p/870514#M1014139 SergeyMak 2015-04-21T05:50:43Z