topic Re: How to replace flash lights instead of trend lines? in QlikView

How to replace flash lights instead of trend lines?

Wed, 26 Feb 2014 15:40:38 GMT

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.

Re: How to replace flash lights instead of trend lines?

Wed, 26 Feb 2014 16:00:39 GMT

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?

Re: How to replace flash lights instead of trend lines?

marcus_sommer — Wed, 26 Feb 2014 16:18:41 GMT

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

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

- Marcus

Re: How to replace flash lights instead of trend lines?

Wed, 26 Feb 2014 16:46:26 GMT

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

Re: How to replace flash lights instead of trend lines?

Thu, 27 Feb 2014 10:44:54 GMT

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

Re: How to replace flash lights instead of trend lines?

marcus_sommer — Thu, 27 Feb 2014 11:11:28 GMT

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

Re: How to replace flash lights instead of trend lines?

Thu, 27 Feb 2014 11:29:26 GMT

Thanks.