Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to replace trendline with flashlight?

Hi,

I have trend line as in attached. Instead of the trend line I would need to show flash lights.


Below are the items which I used


Chart : Combo chart


Dimension1: DaysRange


Dimension2: =IF(Mixmatch(MaxProduct,'Soaps'),MaxProduct)


Expression: =today()-aggr(Date(max(DateInsert)),ProductID)


Trend line: Count(DISTINCT {$<DateType={'InsertDate'},DaysRange={'22-31 Days','32-60 Days','61-90 Days','91+ Days'},Flag={2}>} ProductID)


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?

Please see attached withouttrendline for 0-7 days/2-14 days/15-21 days bars


Thanks.

2 Replies
Not applicable
Author

Please find attached.

Not applicable
Author

Any solution?