topic Re: How to replace trendline with flashlight? in QlikView https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591380#M1112284 <HTML><HEAD></HEAD><BODY><P>Please find attached.</P></BODY></HTML> Mon, 03 Mar 2014 12:08:59 GMT 2014-03-03T12:08:59Z How to replace trendline with flashlight? https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591379#M1112283 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have trend line as in attached. Instead of the trend line I would need to show flash lights.</P><P> <BR />Below are the items which I used</P><P> <BR />Chart : Combo chart</P><P> <BR />Dimension1: DaysRange</P><P> <BR />Dimension2: =IF(Mixmatch(MaxProduct,'Soaps'),MaxProduct)</P><P> <BR />Expression: =today()-aggr(Date(max(DateInsert)),ProductID)</P><P> <BR />Trend line: Count(DISTINCT {$&lt;DateType={'InsertDate'},DaysRange={'22-31 Days','32-60 Days','61-90 Days','91+ Days'},Flag={2}&gt;} ProductID)</P><P> <BR />I need to show the light only if it crosses 15-21 days and if I click on 0-7 days/2-14 days/15-21 days bars I don't want to see the flash light. Please let me know is it possible?</P><P></P><P>Please see attached withouttrendline for 0-7 days/2-14 days/15-21 days bars</P><P> <BR />Thanks.</P></BODY></HTML> Mon, 03 Mar 2014 11:57:07 GMT https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591379#M1112283 2014-03-03T11:57:07Z Re: How to replace trendline with flashlight? https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591380#M1112284 <HTML><HEAD></HEAD><BODY><P>Please find attached.</P></BODY></HTML> Mon, 03 Mar 2014 12:08:59 GMT https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591380#M1112284 2014-03-03T12:08:59Z Re: How to replace trendline with flashlight? https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591381#M1112285 <HTML><HEAD></HEAD><BODY><P>Any solution?</P></BODY></HTML> Tue, 04 Mar 2014 11:32:26 GMT https://community.qlik.com/t5/QlikView/How-to-replace-trendline-with-flashlight/m-p/591381#M1112285 2014-03-04T11:32:26Z