Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to replace flash lights instead of trend lines?

Hi,

can anyone let me know this please. As I have combo chart with

Dimension1: Product

Dimension2: Range of Days

Expression1:  Count(Distinct ProductID) as Bar

Expression2: Count(Distinct ProductID) as Trend line.

This will show as attached in png. I would need to show some flash light instead of trend line if it crosses 21 days. Is it possible to do this?

Thanks.

6 Replies
Not applicable
Author

I found the below link from google

http://www.picgifs.com/graphics/a/alarm-lights/graphics-alarm-lights-687060.gif

But how can I use this?

marcus_sommer
MVP & Luminary
MVP & Luminary

You could use the builtin-trendlines (mid-bottom from expression tab) or try an expression like this:

avg(aggr(count(distinct ProductID), Product))

- Marcus

Not applicable
Author

Thanks for your help. My user wants to see only flash lights whihc is in above URL. Is it possible? Please let me know.

Not applicable
Author

Any Help please? as My user wants to see only flash lights whihc is in above URL. Is it possible? Please let me know.

marcus_sommer
MVP & Luminary
MVP & Luminary

I think this isn't possible within a bar- or line-chart then such expressions-result needed the possibility to shown as picture. If you used a straight-table or a pivot perhaps with gauge- or mini-charts instead numbers you could add an expression which displayed a picture - I'm not sure if animated pictures will be supported.

- Marcus

Not applicable
Author

Thanks.