topic Allert button with condition in QlikView

Allert button with condition

pascos88 — Mon, 14 Dec 2015 09:05:40 GMT

Hello,

I have this small App.

Now I need to have a "button alarm" that it will be red when the avg of a Turbine, it will be higher than 10% of the general avg.

Someone can help me?

Thanks a lot

Regeard

Pasquale

Re: Allert button with condition

robert_mika — Mon, 14 Dec 2015 09:22:43 GMT

For each turbine?

You can have a gouge representation for each of the turbine in form of a button but this will work in straight table only.

Feeling Qlikngry?

How To /Missing Manual(23 articles)

Re: Allert button with condition

pascos88 — Mon, 14 Dec 2015 09:30:02 GMT

hello thnks for the response,

I would like to have for example a botton that it wil be red, in case one o more turbine has the avg higher then 10% of the avg general.

For example if the Turbine 1 have thist condition the botton it will be red and the text will be : 'Turbine 1 allarm'.

is it possible?

Regards

Pasquale

Re: Allert button with condition

pascos88 — Mon, 14 Dec 2015 09:34:27 GMT

This controll, should be do for every range of time that I have (X AXIS).

How I can do it?

Re: Allert button with condition

tamilarasu — Mon, 14 Dec 2015 09:43:27 GMT

Hi Pasquale, !

Not sure, check the attachment and adapt as per your need (If matches your requirement).

Re: Allert button with condition

pascos88 — Mon, 14 Dec 2015 09:53:48 GMT

Hello Tamil,

thanks for the respons.

I just write what I looking for. It is little differnet, becouse I need also to compere each turbine in each period of my x axis. Only in this case (if the temperature of a turbine in this particolar period is > of the 10 % of the general AVG) the allarm button is highlighted.

Regards

Pasquale

Re: Allert button with condition

tamilarasu — Mon, 14 Dec 2015 10:00:15 GMT

Pasquale,

Could you explain me with example. On what selection, the alert should display?

Re: Allert button with condition

rubenmarin — Mon, 14 Dec 2015 10:10:36 GMT

Hi Pasquale, maybe this expression:

If(Sum(Aggr(If(avg(Temperature)-avg(TOTAL <Class_PP> {<Turbine=>}Temperature)>10, 1, 0), Turbine, Class_PP)), Red(), Green())

I don't find any instance that goes red so I can't test if it's really working, it should go red if for any Class_PP (The period?) the avg of a turbine is 10 point higher than the avg for all turbines in that Class_PP.

Re: Allert button with condition

pascos88 — Mon, 14 Dec 2015 10:13:21 GMT

Sure.

I need to compare the avg of each turgin with the genereal AVG (red line in my chart).

If for some period (That I dont know I manage it) the avg of some turbine (E1 or E2 atc) is > of the 10 % of the general AVG (red line), I need an allarm.

In this case, for example let me considerer that the Yellow line is more then 105 of the red line.

In this case the I need the allarm.

Regards

Re: Allert button with condition

pascos88 — Mon, 14 Dec 2015 10:14:17 GMT

In this case, for example let me considerer that the Yellow line is more then 10% of the red line.

In this case the I need the allarm.

Sorry

Re: Allert button with condition

rubenmarin — Mon, 14 Dec 2015 10:20:28 GMT

For higher than 10% it can be:

If(Sum(Aggr(If(avg(TOTAL <Class_PP> {<Turbine=>}Temperature)/avg(Temperature)>1.1, 1, 0), Turbine, Class_PP)), Red(), Green())

Re: Allert button with condition

pascos88 — Mon, 14 Dec 2015 10:35:31 GMT

Hi Ruben thanks for reply.

So Class_PP is not time, I was wrong, I put an immage above in order to better undertand what I need.

Do you have some advoces to give me? How I can do it?

Re: Allert button with condition

rubenmarin — Mon, 14 Dec 2015 10:53:12 GMT

Not sure to understand this last one. Class_PP it's not the time but it's the dimension of the chart?

You can add a dot in the chart as an expression with symbol (dot) representation:

- Expression: If(Sum(Aggr(If(Avg(Temperature)/Avg(TOTAL <Class_PP> {<Turbine=>}Temperature)>1.1, 1, 0), Turbine, Class_PP)), Avg(Temperature))

- Representation options: Symbol(dots)

- Background color: Red(128) //Semitransparent

- Symbol size(presentation tab): 5 or 6 points

Re: Allert button with condition

effinty2112 — Mon, 14 Dec 2015 12:06:08 GMT

Hi Pasquale,

If you add Day and Time fields to your data set it makes it a bit easier to navigate then a pivot table like this might work for you.

I've selected the day 11/12/2015 and between 00:00:00 and 03:00:00 and the table shows all the temperature data for all the turbines over that time. The average temperature across all the readings is 37.86. The text colour is set as

if(avg(Temperature)>= avg(TOTAL <datetime>Temperature)*1.1,Red())

background:

if(avg(Temperature)>= avg(TOTAL <datetime>Temperature)*1.1,RGB(250,250,210))

By picking whatever date range and times you want to average over the pivot table will show the temperatures and highlight the ones in excess of 110% of the average.

		Windpark	Bazoches						Pithiviers					Sermaises
Day	Time	Turbine	E1	E2	E3	E4	E5	E6	E1	E2	E3	E4	E5	E1	E2	E3	E4	E5	E6
11/12/2015	00:00:00		33.0	39.0	33.0	33.0	31.0	35.0	40.0	39.0	40.0	38.0	37.0	33.0	36.0	27.0	27.0	31.0	22.0
	00:10:00		33.0	38.0	33.0	32.0	31.0	34.0	40.0	38.0	40.0	38.0	37.0	33.0	35.0	27.0	27.0	31.0	21.0
	00:20:00		33.0	37.0	32.0	32.0	31.0	33.0	40.0	38.0	39.0	39.0	38.0	33.0	34.0	26.0	27.0	31.0	21.0
	00:30:00		33.0	36.0	32.0	32.0	30.0	32.0	40.0	38.0	39.0	39.0	38.0	33.0	34.0	26.0	27.0	31.0	21.0
	00:40:00		33.0	35.0	32.0	32.0	30.0	31.0	41.0	38.0	39.0	40.0	39.0	33.0	33.0	26.0	27.0	31.0	21.0
	00:50:00		35.0	35.0	31.0	32.0	29.0	31.0	41.0	39.0	39.0	40.0	39.0	33.0	33.0	26.0	27.0	32.0	21.0
	01:00:00		36.0	34.0	31.0	33.0	29.0	30.0	42.0	39.0	40.0	40.0	40.0	33.0	32.0	27.0	27.0	32.0	21.0
	01:10:00		37.0	33.0	31.0	34.0	29.0	30.0	42.0	39.0	40.0	41.0	40.0	33.0	32.0	26.0	27.0	31.0	21.0
	01:20:00		38.0	32.0	31.0	34.0	29.0	29.0	43.0	40.0	41.0	41.0	41.0	33.0	31.0	26.0	27.0	31.0	21.0
	01:30:00		39.0	32.0	32.0	35.0	30.0	28.0	44.0	41.0	41.0	42.0	42.0	33.0	30.0	26.0	27.0	30.0	21.0
	01:40:00		40.0	33.0	33.0	36.0	30.0	28.0	44.0	41.0	42.0	42.0	42.0	32.0	30.0	26.0	26.0	29.0	20.0
	01:50:00		40.0	33.0	33.0	37.0	31.0	29.0	45.0	41.0	42.0	42.0	43.0	33.0	30.0	26.0	26.0	29.0	20.0
	02:00:00		41.0	34.0	34.0	37.0	32.0	30.0	45.0	42.0	43.0	41.0	43.0	33.0	30.0	26.0	26.0	30.0	20.0
	02:10:00		41.0	36.0	34.0	37.0	32.0	31.0	46.0	42.0	44.0	40.0	43.0	33.0	30.0	26.0	26.0	32.0	20.0
	02:20:00		42.0	38.0	36.0	38.0	34.0	32.0	47.0	43.0	44.0	40.0	43.0	34.0	30.0	26.0	26.0	34.0	20.0
	02:30:00		41.0	39.0	37.0	40.0	35.0	32.0	47.0	44.0	45.0	40.0	42.0	34.0	30.0	26.0	26.0	36.0	20.0
	02:40:00		40.0	40.0	38.0	40.0	36.0	33.0	48.0	44.0	46.0	40.0	42.0	35.0	31.0	28.0	27.0	39.0	20.0
	02:50:00		39.0	41.0	39.0	40.0	37.0	33.0	48.0	44.0	46.0	40.0	42.0	36.0	32.0	30.0	27.0	42.0	20.0
	03:00:00		37.0	41.0	39.0	39.0	37.0	34.0	48.0	44.0	46.0	38.0	42.0	36.0	33.0	31.0	28.0	42.0	20.0

Re: Allert button with condition

pascos88 — Tue, 15 Dec 2015 09:50:03 GMT

Hello Andrew,

this is a good solution, but I need to have a Line Chart to show this.

Maybe I cann add the time, but I should change also the chart, it is true?

Really thanks for the Reply

Pasquale

Re: Allert button with condition

effinty2112 — Tue, 15 Dec 2015 16:03:57 GMT

Hi Pasquale,

Have a look at this qvw and see what your think.

cheers

Andrew