Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What's wrong with my Alert expression?

Hello,

I am attempting to set up an alert that checks a threshold after my dashboard refreshes (currently reloading every 6 minutes). This monitors eCommerce traffic so it's pretty important to the business.

In the alert menu, I have the condition set as the following:

sum(if(hour(ReloadTime())>=Created_Time,ACCOUNT))/sum(if(hour(ReloadTime())>=LastWeek_Date,LastWeek_ACCOUNT/5))<.75

I am already using this same expression (minus the <.75) as a gauge in my dashboard to monitor and it works fine. The output of the expression is a value between 0 and 1 with the following thresholds for the gauge:

0-.74 =RED

.75-.99 = YELLOW

1 or greater = GREEN

I am simply trying to replicate this expression as a push alert that pops up or sends an email when the RED threshold is released, in other words, when the value is less than .75

The output to my understanding needs to be true or false values, which looks to be the case in the expression above (either 0 or -1 is returned). What am I doing wrong?

1 Reply
Not applicable
Author

Hi Philip,

Did you manage to solve your issue ?

If not, a sample document would be helpful to test on your real case.

Regards,

JP