topic QlikView Trend line Linear function? in QlikView https://community.qlik.com/t5/QlikView/QlikView-Trend-line-Linear-function/m-p/1248557#M395501 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to use default QlikView Trend Line Linear function in expression and shows legends.</P><P></P><P>Sample Data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 328px;"><TBODY><TR><TD height="20" width="71">DATE</TD><TD width="128">TOTAL MESSAGES</TD><TD width="129">MSG PER SECOND</TD></TR><TR><TD height="20">2016-11-21</TD><TD>8110</TD><TD>4.50555555555556</TD></TR><TR><TD height="20">2016-11-22</TD><TD>8877</TD><TD>4.93166666666667</TD></TR><TR><TD height="20">2016-11-23</TD><TD>10080</TD><TD>5.6</TD></TR><TR><TD height="20">2016-11-28</TD><TD>11147</TD><TD>6.19277777777778</TD></TR><TR><TD height="20">2016-11-29</TD><TD>10557</TD><TD>5.865</TD></TR><TR><TD height="20">2016-11-30</TD><TD>8362</TD><TD>4.64555555555556</TD></TR><TR><TD height="20">2016-12-01</TD><TD>6542</TD><TD>3.63444444444444</TD></TR><TR><TD height="20">2016-12-02</TD><TD>2934</TD><TD>1.63</TD></TR><TR><TD height="20">2016-12-05</TD><TD>9285</TD><TD>5.15833333333333</TD></TR><TR><TD height="20">2016-12-06</TD><TD>6133</TD><TD>3.40722222222222</TD></TR><TR><TD height="20">2016-12-07</TD><TD>9323</TD><TD>5.17944444444444</TD></TR><TR><TD height="20">2016-12-08</TD><TD>7427</TD><TD>4.12611111111111</TD></TR><TR><TD height="20">2016-12-09</TD><TD>9775</TD><TD>5.43055555555556</TD></TR><TR><TD height="20">2016-12-12</TD><TD>10251</TD><TD>5.695</TD></TR><TR><TD height="20">2016-12-13</TD><TD>9301</TD><TD>5.16722222222222</TD></TR><TR><TD height="20">2016-12-14</TD><TD>8633</TD><TD>4.79611111111111</TD></TR><TR><TD height="20">2016-12-15</TD><TD>8441</TD><TD>4.68944444444444</TD></TR><TR><TD height="20">2016-12-16</TD><TD>8658</TD><TD>4.81</TD></TR><TR><TD height="20">2016-12-19</TD><TD>9335</TD><TD>5.18611111111111</TD></TR><TR><TD height="20">2016-12-20</TD><TD>9939</TD><TD>5.52166666666667</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Lawrance. A</P></BODY></HTML> Thu, 29 Dec 2016 12:10:46 GMT lawrance 2016-12-29T12:10:46Z QlikView Trend line Linear function? https://community.qlik.com/t5/QlikView/QlikView-Trend-line-Linear-function/m-p/1248557#M395501 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to use default QlikView Trend Line Linear function in expression and shows legends.</P><P></P><P>Sample Data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 328px;"><TBODY><TR><TD height="20" width="71">DATE</TD><TD width="128">TOTAL MESSAGES</TD><TD width="129">MSG PER SECOND</TD></TR><TR><TD height="20">2016-11-21</TD><TD>8110</TD><TD>4.50555555555556</TD></TR><TR><TD height="20">2016-11-22</TD><TD>8877</TD><TD>4.93166666666667</TD></TR><TR><TD height="20">2016-11-23</TD><TD>10080</TD><TD>5.6</TD></TR><TR><TD height="20">2016-11-28</TD><TD>11147</TD><TD>6.19277777777778</TD></TR><TR><TD height="20">2016-11-29</TD><TD>10557</TD><TD>5.865</TD></TR><TR><TD height="20">2016-11-30</TD><TD>8362</TD><TD>4.64555555555556</TD></TR><TR><TD height="20">2016-12-01</TD><TD>6542</TD><TD>3.63444444444444</TD></TR><TR><TD height="20">2016-12-02</TD><TD>2934</TD><TD>1.63</TD></TR><TR><TD height="20">2016-12-05</TD><TD>9285</TD><TD>5.15833333333333</TD></TR><TR><TD height="20">2016-12-06</TD><TD>6133</TD><TD>3.40722222222222</TD></TR><TR><TD height="20">2016-12-07</TD><TD>9323</TD><TD>5.17944444444444</TD></TR><TR><TD height="20">2016-12-08</TD><TD>7427</TD><TD>4.12611111111111</TD></TR><TR><TD height="20">2016-12-09</TD><TD>9775</TD><TD>5.43055555555556</TD></TR><TR><TD height="20">2016-12-12</TD><TD>10251</TD><TD>5.695</TD></TR><TR><TD height="20">2016-12-13</TD><TD>9301</TD><TD>5.16722222222222</TD></TR><TR><TD height="20">2016-12-14</TD><TD>8633</TD><TD>4.79611111111111</TD></TR><TR><TD height="20">2016-12-15</TD><TD>8441</TD><TD>4.68944444444444</TD></TR><TR><TD height="20">2016-12-16</TD><TD>8658</TD><TD>4.81</TD></TR><TR><TD height="20">2016-12-19</TD><TD>9335</TD><TD>5.18611111111111</TD></TR><TR><TD height="20">2016-12-20</TD><TD>9939</TD><TD>5.52166666666667</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Lawrance. A</P></BODY></HTML> Thu, 29 Dec 2016 12:10:46 GMT https://community.qlik.com/t5/QlikView/QlikView-Trend-line-Linear-function/m-p/1248557#M395501 lawrance 2016-12-29T12:10:46Z