topic Why does my Alert pop-up not apear? in QlikView

Why does my Alert pop-up not apear?

Wed, 07 Dec 2011 10:11:21 GMT

I have setup an alert, which does not seem to work.

In the condition field I have the following:

=if(ArrivalTimeLeft>'00:00:00' and ArrivalTimeLeft < '01:00:00',1,'')

This does not work.

I know I have at least one row which matches this value, because I also created a list box with this expression.

When I enter '1' in the condition field, it does show the alert.

Thanks in advance.

Erik

erichshiino — Wed, 07 Dec 2011 11:01:58 GMT

You said that you have at least one line that matches, but with this expressions you could have only one value for ArrivalTimeLeft.

You can try to change it to a count:

if( count ( if(ArrivalTimeLeft>'00:00:00' and ArrivalTimeLeft < '01:00:00', ArrivalTimeLeft)> 1, 1,0)

Then, if it works, you can try to write in as set analysis to get a better performance.

if( count( {<ArrivalTimeLeft = {">'00:00:00' <'01:00:00' " }>} ArrivalTimeLeft )>1, 1,0)

Hope this helps,

Erich

Wed, 07 Dec 2011 13:14:48 GMT

Thanks for your help.

The below was the solution for my issue.

=count ( if(ArrivalTimeLeft>'00:00:00' and ArrivalTimeLeft < '01:00:00',1,'')>0)