topic Alert Condition in QlikView

Alert Condition

Tue, 20 May 2014 18:43:03 GMT

Hello All,

I have an expression stdev1 and another expression delta probe1 which has say 100000 values, I want to trigger a pop-up alert each times the expression delta probe1 goes below expression delta probe1 (say static value 1), can someone help me out here?

Re: Alert Condition

swuehl — Tue, 20 May 2014 18:48:25 GMT

... the expression delta probe1 goes below expression delta probe1 ...

You probably want to compare against stdev1, right?

Have you tried creating two variables from your two expressions, then use a condition like

= vDeltaProbe1 < vStdev1

It might be easier to help if you explain a little more detailed how your expressions look like.

Re: Alert Condition

Tue, 20 May 2014 19:34:17 GMT

Hi,

One of my expressions is DeltaProbe1:

temp

and second expression is

Stdev1:

stdev(TOTAL Aggr(Sum(temp), row_id))