topic Pivot Formula Not Working in Line Graph in QlikView https://community.qlik.com/t5/QlikView/Pivot-Formula-Not-Working-in-Line-Graph/m-p/172546#M42056 <HTML><HEAD></HEAD><BODY><P>Hi...</P><P>I have the following formula which works okay in a pivot table...</P><P></P><P></P><P>=</P><P>IF(cam_Sequence &gt;11,rangeavg(after(sum(sin_Qty),0,12)))</P><BR /><BR /> <BR /><BR /> <P>I have been asked to show this as a line graph but am getting "no data to display" returned...</P><P>I think I have read other posts that formula that works in pivots may not necessarily translate to graphs...</P><P>Does anyone have any ideas how I can get this formula to work in a line graph?</P></BODY></HTML> Tue, 09 Mar 2010 12:03:29 GMT pkelly 2010-03-09T12:03:29Z Pivot Formula Not Working in Line Graph https://community.qlik.com/t5/QlikView/Pivot-Formula-Not-Working-in-Line-Graph/m-p/172546#M42056 <HTML><HEAD></HEAD><BODY><P>Hi...</P><P>I have the following formula which works okay in a pivot table...</P><P></P><P></P><P>=</P><P>IF(cam_Sequence &gt;11,rangeavg(after(sum(sin_Qty),0,12)))</P><BR /><BR /> <BR /><BR /> <P>I have been asked to show this as a line graph but am getting "no data to display" returned...</P><P>I think I have read other posts that formula that works in pivots may not necessarily translate to graphs...</P><P>Does anyone have any ideas how I can get this formula to work in a line graph?</P></BODY></HTML> Tue, 09 Mar 2010 12:03:29 GMT https://community.qlik.com/t5/QlikView/Pivot-Formula-Not-Working-in-Line-Graph/m-p/172546#M42056 pkelly 2010-03-09T12:03:29Z Pivot Formula Not Working in Line Graph https://community.qlik.com/t5/QlikView/Pivot-Formula-Not-Working-in-Line-Graph/m-p/172547#M42057 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P>see QV help. "After" is for pivot table only. Try to use an expression like this: <B></B></P><P style="font-weight: bold">RangeSum</P>(above(Sum(UmsatzBestZeile), <B></B><P style="font-weight: bold"></P>(above(Sum(UmsatzBestZeile), 0<B>,</B> 3<B>)) or below</B> <P>Good luck!</P><P>Rainer</P><BR /><BR /> <P>(above(Sum(UmsatzBestZeile),</P></BODY></HTML> Tue, 09 Mar 2010 14:04:56 GMT https://community.qlik.com/t5/QlikView/Pivot-Formula-Not-Working-in-Line-Graph/m-p/172547#M42057 2010-03-09T14:04:56Z