Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
This controll, should be do for every range of time that I have (X AXIS).
How I can do it?
Hi Pasquale, !
Not sure, check the attachment and adapt as per your need (If matches your requirement).
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
Pasquale,
Could you explain me with example. On what selection, the alert should display?
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.
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
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