topic Re: Waterfall chart with total bar in QlikView https://community.qlik.com/t5/QlikView/Waterfall-chart-with-total-bar/m-p/844095#M995650 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>did you get a correct answer?&nbsp; I have the same issue. </P><P></P><P>Cheers</P></BODY></HTML> Thu, 21 Jan 2016 16:39:49 GMT Anonymous 2016-01-21T16:39:49Z Waterfall chart with total bar https://community.qlik.com/t5/QlikView/Waterfall-chart-with-total-bar/m-p/844094#M995648 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to make a simple waterfall diagram with an initial Total bar. The waterfall components are over several "years" is working fine, using for the offset the formula:</P><P><SPAN style="font-size: 8pt;">Sum(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) - </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">()-1) - </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RangeSum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">), 0, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">()-1))</SPAN></P><P>Unfortunately, I don't know how to add an initial bar with the total sum of all the years:</P><P><SPAN style="font-size: 8pt;">Sum(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P><P><SPAN style="font-size: 10pt;">Can anybody give me an advice on how to implement this?</SPAN></P><P><SPAN style="font-size: 10pt;">Thanks</SPAN></P></BODY></HTML> Mon, 29 Jun 2015 14:38:59 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart-with-total-bar/m-p/844094#M995648 2015-06-29T14:38:59Z Re: Waterfall chart with total bar https://community.qlik.com/t5/QlikView/Waterfall-chart-with-total-bar/m-p/844095#M995650 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>did you get a correct answer?&nbsp; I have the same issue. </P><P></P><P>Cheers</P></BODY></HTML> Thu, 21 Jan 2016 16:39:49 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart-with-total-bar/m-p/844095#M995650 Anonymous 2016-01-21T16:39:49Z