Hi,
How to use default QlikView Trend Line Linear function in expression and shows legends.
Sample Data:
DATE | TOTAL MESSAGES | MSG PER SECOND |
2016-11-21 | 8110 | 4.50555555555556 |
2016-11-22 | 8877 | 4.93166666666667 |
2016-11-23 | 10080 | 5.6 |
2016-11-28 | 11147 | 6.19277777777778 |
2016-11-29 | 10557 | 5.865 |
2016-11-30 | 8362 | 4.64555555555556 |
2016-12-01 | 6542 | 3.63444444444444 |
2016-12-02 | 2934 | 1.63 |
2016-12-05 | 9285 | 5.15833333333333 |
2016-12-06 | 6133 | 3.40722222222222 |
2016-12-07 | 9323 | 5.17944444444444 |
2016-12-08 | 7427 | 4.12611111111111 |
2016-12-09 | 9775 | 5.43055555555556 |
2016-12-12 | 10251 | 5.695 |
2016-12-13 | 9301 | 5.16722222222222 |
2016-12-14 | 8633 | 4.79611111111111 |
2016-12-15 | 8441 | 4.68944444444444 |
2016-12-16 | 8658 | 4.81 |
2016-12-19 | 9335 | 5.18611111111111 |
2016-12-20 | 9939 | 5.52166666666667 |
Thanks,
Lawrance. A