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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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?