topic Charting Rolling Average Totals in QlikView https://community.qlik.com/t5/QlikView/Charting-Rolling-Average-Totals/m-p/418871#M155826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table where I am calculating the rolling average of a data series with each collum at different roll lengths (Collumn 1 is 1 second, 2 is 2 second etc.)</P><P></P><P>I have the values for all the averages in the total using the max of expression total mode in the total row of the straight table. What I want to do is plot these maximum values in a line chart accross the roll length to show decrease/increase as the time period increases. I've tried using variables but had no joy. I have put the expression I'm using and an image of the table below. </P><P></P><P>Any ideas would be greatly appreciated!!!</P><P></P><P></P><P><IMG __jive_id="26604" class="jive-image-thumbnail jive-image" onclick="" alt="Table.png" src="https://community.qlik.com/legacyfs/online/26604_Table.png" width="450" /></P><P></P><P>rangesum</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Power per revolution W]</SPAN><SPAN style="font-size: 8pt;">,0,1&nbsp; )) / 1 </SPAN></P><P></P><P>rangesum</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Power per revolution W]</SPAN><SPAN style="font-size: 8pt;">,0,2&nbsp; )) / 2 </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">etc.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Cheers</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Matt</SPAN></P></BODY></HTML> Sun, 09 Dec 2012 18:30:26 GMT 2012-12-09T18:30:26Z Charting Rolling Average Totals https://community.qlik.com/t5/QlikView/Charting-Rolling-Average-Totals/m-p/418871#M155826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table where I am calculating the rolling average of a data series with each collum at different roll lengths (Collumn 1 is 1 second, 2 is 2 second etc.)</P><P></P><P>I have the values for all the averages in the total using the max of expression total mode in the total row of the straight table. What I want to do is plot these maximum values in a line chart accross the roll length to show decrease/increase as the time period increases. I've tried using variables but had no joy. I have put the expression I'm using and an image of the table below. </P><P></P><P>Any ideas would be greatly appreciated!!!</P><P></P><P></P><P><IMG __jive_id="26604" class="jive-image-thumbnail jive-image" onclick="" alt="Table.png" src="https://community.qlik.com/legacyfs/online/26604_Table.png" width="450" /></P><P></P><P>rangesum</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Power per revolution W]</SPAN><SPAN style="font-size: 8pt;">,0,1&nbsp; )) / 1 </SPAN></P><P></P><P>rangesum</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Power per revolution W]</SPAN><SPAN style="font-size: 8pt;">,0,2&nbsp; )) / 2 </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">etc.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Cheers</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Matt</SPAN></P></BODY></HTML> Sun, 09 Dec 2012 18:30:26 GMT https://community.qlik.com/t5/QlikView/Charting-Rolling-Average-Totals/m-p/418871#M155826 2012-12-09T18:30:26Z