topic Waterfall and changed behaviour of the Total function in QV11 in QlikView https://community.qlik.com/t5/QlikView/Waterfall-and-changed-behaviour-of-the-Total-function-in-QV11/m-p/369387#M577265 <HTML><HEAD></HEAD><BODY><P>change the offset formula to use if(dimensionality=0,0,</P><P>instead of if(rowno()=1,0</P></BODY></HTML> Mon, 26 Mar 2012 14:12:19 GMT 2012-03-26T14:12:19Z Waterfall and changed behaviour of the Total function in QV11 https://community.qlik.com/t5/QlikView/Waterfall-and-changed-behaviour-of-the-Total-function-in-QV11/m-p/369386#M577264 <HTML><HEAD></HEAD><BODY><P>I had this nice Waterfall chart in QV10 (SR2) which was building a total at the end of the chart.</P><P><IMG alt="waterfall10.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/12427_waterfall10.png" /></P><P>The way it looks now in QV 11 is:</P><P><IMG alt="waterfall11.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/12431_waterfall11.png" /></P><P>Not the same...</P><P>I am using the offset function. Did anyone had the same issue and get a solution for that?</P><P>Attached is also the qvw. Opening it in QV10 or QV11 gives you a different view.</P><P>Thanks!</P></BODY></HTML> Mon, 26 Mar 2012 14:05:34 GMT https://community.qlik.com/t5/QlikView/Waterfall-and-changed-behaviour-of-the-Total-function-in-QV11/m-p/369386#M577264 2012-03-26T14:05:34Z Waterfall and changed behaviour of the Total function in QV11 https://community.qlik.com/t5/QlikView/Waterfall-and-changed-behaviour-of-the-Total-function-in-QV11/m-p/369387#M577265 <HTML><HEAD></HEAD><BODY><P>change the offset formula to use if(dimensionality=0,0,</P><P>instead of if(rowno()=1,0</P></BODY></HTML> Mon, 26 Mar 2012 14:12:19 GMT https://community.qlik.com/t5/QlikView/Waterfall-and-changed-behaviour-of-the-Total-function-in-QV11/m-p/369387#M577265 2012-03-26T14:12:19Z