topic Stackbar & Waterfall chart in QlikView https://community.qlik.com/t5/QlikView/Stackbar-Waterfall-chart/m-p/284332#M105676 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a Waterfall chart correctly displaying.&nbsp;&nbsp; Using the Offset function to postion the components.</P><P>E.g.&nbsp; </P><P></P><P>List-Rev&nbsp;&nbsp;&nbsp; Rebates&nbsp; Fees&nbsp;&nbsp; Net-Revenue&nbsp;&nbsp; COGS&nbsp; Net-Margin.</P><P></P><P>I would like to make it stack bar by Product.&nbsp;&nbsp;&nbsp; So&nbsp;&nbsp; </P><P>List-Rev would be a stackbar for prod1..prodN</P><P>Same with Rebates. </P><P></P><P>However, I cannot seem to figure out what function to use for the offset. </P><P></P><P>For Rebates offset i tried sum(List-Rev)&nbsp; anda sum(Total List-Rev).&nbsp; with no luck.</P><P></P><P>Ideas.</P><P>Bernard&nbsp; </P></BODY></HTML> Fri, 19 Aug 2011 03:56:08 GMT 2011-08-19T03:56:08Z Stackbar & Waterfall chart https://community.qlik.com/t5/QlikView/Stackbar-Waterfall-chart/m-p/284332#M105676 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a Waterfall chart correctly displaying.&nbsp;&nbsp; Using the Offset function to postion the components.</P><P>E.g.&nbsp; </P><P></P><P>List-Rev&nbsp;&nbsp;&nbsp; Rebates&nbsp; Fees&nbsp;&nbsp; Net-Revenue&nbsp;&nbsp; COGS&nbsp; Net-Margin.</P><P></P><P>I would like to make it stack bar by Product.&nbsp;&nbsp;&nbsp; So&nbsp;&nbsp; </P><P>List-Rev would be a stackbar for prod1..prodN</P><P>Same with Rebates. </P><P></P><P>However, I cannot seem to figure out what function to use for the offset. </P><P></P><P>For Rebates offset i tried sum(List-Rev)&nbsp; anda sum(Total List-Rev).&nbsp; with no luck.</P><P></P><P>Ideas.</P><P>Bernard&nbsp; </P></BODY></HTML> Fri, 19 Aug 2011 03:56:08 GMT https://community.qlik.com/t5/QlikView/Stackbar-Waterfall-chart/m-p/284332#M105676 2011-08-19T03:56:08Z