topic How to make Trend indicator by traffic lights in QlikView https://community.qlik.com/t5/QlikView/How-to-make-Trend-indicator-by-traffic-lights/m-p/276717#M1205305 <HTML><HEAD></HEAD><BODY><P>After studying the case further I found solution. I made a chart-pivot table where Used Dimension is "Unit". In Expression I made "Trendlight" expression and definition as =linest_m(aggr(sum(Value),Unit,Datestamp),Datestamp) . Then I selected Representation "Traffic Light" where I set the limits. This made the work.</P></BODY></HTML> Thu, 16 Sep 2010 11:52:58 GMT 2010-09-16T11:52:58Z How to make Trend indicator by traffic lights https://community.qlik.com/t5/QlikView/How-to-make-Trend-indicator-by-traffic-lights/m-p/276716#M1205304 <HTML><HEAD></HEAD><BODY><P>I have a dataset that contains "Datestamp", "Unit" and "Value" columns. I need to make a indicator by using traffic lights showing if trend has been down, equal or up during last 2 weeks (14 days). I tried to start by looking help for <I>linest_m</I> but that with no result.</P><P>Any ideas how make this? All help is appreciated.</P></BODY></HTML> Wed, 15 Sep 2010 15:17:07 GMT https://community.qlik.com/t5/QlikView/How-to-make-Trend-indicator-by-traffic-lights/m-p/276716#M1205304 2010-09-15T15:17:07Z How to make Trend indicator by traffic lights https://community.qlik.com/t5/QlikView/How-to-make-Trend-indicator-by-traffic-lights/m-p/276717#M1205305 <HTML><HEAD></HEAD><BODY><P>After studying the case further I found solution. I made a chart-pivot table where Used Dimension is "Unit". In Expression I made "Trendlight" expression and definition as =linest_m(aggr(sum(Value),Unit,Datestamp),Datestamp) . Then I selected Representation "Traffic Light" where I set the limits. This made the work.</P></BODY></HTML> Thu, 16 Sep 2010 11:52:58 GMT https://community.qlik.com/t5/QlikView/How-to-make-Trend-indicator-by-traffic-lights/m-p/276717#M1205305 2010-09-16T11:52:58Z